How to get the usage information of Cache for Confluence app

Owned by Former user (Deleted)
Last updated: Apr 20, 2020 by Smita Nair
1 min read

This article explains how to get a list of the Confluence pages and their 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 Cog wheel > General configuration > Administration > Macro Usage:

You can see all the macro usage information like the number of pages (link redirecting respective pages) that are using the app in the Macro Usage section as shown:

Usage information using SQL queries:

Connect to the Confluence database and run the following 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"%');

If the query returns any records, it indicates that the Cache for Confluence app is being used. The above query gives a result similar to:

It is recommended to: 

  • Test the above queries in a test environment. The time taken to get the results is based on the number of pages where the macro has been used.
  • Run the query in the off-business hours to reduce any impact caused due to the run time of the query.