Page Comparison

The below article helps you to get the usage information the run macros in the confluence page>

Instructions

The below steps help you to get the usage information of the app from the 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 two three macros, execute the below two three queries to get the macro-level usage information.

1. For Run with a user form and parameter (Run) macro):
   

   Code Block
   theme Midnight
   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):
   

   Code Block
   theme Midnight
   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"%');

...

1. 
   

2. For Hide content macro:
   

   Code Block
   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"%');