How to list the most used labels in Confluence

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

As an administrator, I'd like to have the precise number of times each label has been added to a content.


Solution

The following query produces a list with the label name and the number of pages or attachments containing that label:


SELECT count(*) AS label_count,
       l.name AS label_name
FROM label l
JOIN content_label c_l ON l.labelid = c_l.labelid
JOIN content c ON c.contentid = c_l.contentid
WHERE l.namespace = 'global'
GROUP BY label_name
ORDER BY label_count DESC;



Last modified on Sep 28, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.