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

The below article helps you to get the usage information of the run macros that are in the confluence page:

Instructions

The below steps help you to get the usage information of the app from the confluence UI.

1. Navigate to General configuration from the cogwheel.
   
2. Navigate to Macro Usage from Administration.
   
3. Here in the Macro Usage section, we can get all the app/macro usage information like the number of pages (with the link which will redirect to the respective pages) that are using the app.
   

Follow the below steps to get the usage information from the database using the SQL query:

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 parameter (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"%');