Query to show all the spaces that have Scaffolding macros with information.
In this guide, we'll explore a useful SQL query that helps identify spaces within your instance that contain Scaffolding macros with information. Whether you're preparing for a migration or conducting an audit, this query can be helpful in pinpointing relevant content.
Instructions
Query to List Spaces with Scaffolding information:
SELECT c.contentid, c.title, s.spacekey, s.spacename
FROM CONTENT c
JOIN OS_PROPERTYENTRY o
ON c.contentid = o.entity_id
JOIN SPACES s
ON c.spaceid = s.spaceid
where c.prevver is NULL and c.contentid=o.entity_id and o.entity_key like '%metadata.%';Result example:
This query will only return results for spaces containing Scaffolding macros with associated metadata, i.e with information on them. Spaces with Scaffolding macros that don't have any data will not be included in the results.
By utilizing this query, you can gain insights into where Scaffolding macros are actively used, helping you make informed decisions regarding your Confluence content.