How to get usage information about Run Self-Service Reports for Confluence app

This article explains how to get a list of Confluence pages in the respective spaces where the Run Self-Service Reports for Confluence app is used.

Instructions

Usage information from the Macro Usage option in the Confluence Administration section:

1. Navigate to General configuration from the cogwheel:
   
2. Navigate to Macro Usage from Administration on the left side panel:
   
3. In the Macro Usage section, it will show the number of pages the respective macro is used. 
   

Usage information using SQL queries:

As the Run Self-Service Reports for Confluence is having three macros, execute the below three queries to get the macro-level usage information. The output includes the Title of the page and SpaceID of the respective pages as mentioned in the query.

1. For Run with a user form and parameters (Run) macro, execute the below 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="run"%');

2. For Run with a user from (Run-now) macro, execute the below 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="run-now"%');

3. For Hide content macro, execute the below 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="hide"%');

   
   

Sample Results:

If the query returns any records, it indicates that the Run Self-Service Reports for Confluence app is being used. The above query gives the result as shown: