Skip to end of banner
Go to start of banner

How to get the usage information of Cache for Confluence app

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

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:

  1. Navigate to Confluence's General configuration from the cogwheel:
  2. Navigate to Macro Usage from Administration on the left side panel:
  3. 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. 
  • No labels