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.
\uD83D\uDCD8 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.