Label Analysis for a Space

[Patrick Hampel]

Hello,

I'am beginner with confluence and just received the editor-position for my team. We are using Confluence to create documentations about technical environments. This week we achieved the milestone of 1.200 sites. And now we are struggling, because some of us missed the labling!

So I'm looking for an option to get a summary of all pages and their labels of the space. Is this possible with the integrated tools and macros? Do I have to contact an admin? How can he do such a query?

Sincerely

Paddi

[Mike Bowen · Accepted solution]

Hi @Patrick Hampel 

It would be very useful indeed in Confluence Cloud, but alas, it seems it is not possible. See this post. Looks like a request by many but one needs to vote on it. 

• CONFCLOUD-43823

Please vote and comment on that with your usage case.

- Mike

[Jeff Turner · Accepted solution]

I can't think of a way of listing all pages and their labels. It would be trivial to do with SQL if you could query the Confluence database:

SELECT label.name, content.title FROM label JOIN content_label USING (labelid) JOIN content USING (contentid) ;