This article explains how to get a list of Confluence pages in the respective spaces where the Cache for Confluence app is used.
Instructions
Usage information from the Macro Usage option in the Confluence Administration section:
- Navigate to Confluence's General configuration from the cogwheel:
- Navigate to Macro Usage from Administration on the left side panel:
- In the Macro Usage section, you can see all the macro usage information like the number of pages (link redirecting respective pages) that are using the app:
Usage information using SQL queries:
Connect to the Database and run the following database query:
Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="cache"%');
Sample Results:
If the query returns any records, it indicates that the Cache for Confluence app is being used. The above query gives the result as shown:
- Please test the above queries in the test environment database. It may take time to provide the results, based on the number of pages the macro has been used.
- Suggest to run the queries in the off business hours.