How do I pull up a list of all blogs on my Confluence instance?

[Jim]

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).

[Davin Studer]

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

[Noumenon72]

For people Googling how to see all blog posts, not all blogs -- Search has a filter for "Type: Blog Post".