How to list the most used labels in Confluence
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
Powered by Confluence and Scroll Viewport.