We have approximately 80 spaces in our Confluence instance, many of which have blogs associated with them. Some of those blogs have never had any blogposts published on them.
How do I pull a list of all the blogs (not blogposts) that exist in my Confluence? The list under Organize Spaces & Categories is not complete (it has to be updated manually).
If you have access to running a SQL query this should get you what you want.
select S.SPACENAME from dbo.CONTENT C inner join SPACES S on C.SPACEID = S.SPACEID where C.CONTENTTYPE = 'BLOGPOST' and C.SPACEID is not null group by S.SPACENAME
For people Googling how to see all blog posts, not all blogs -- Search has a filter for "Type: Blog Post".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.