The below article helps you to get the usage information of the Run macros that are in a Confluence page:
Instructions
- Navigate to General configuration from the cogwheel:
- Navigate to Macro Usage from Administration on the left side panel:
- In the Macro Usage section, you get all the app usage information like the number of pages (linking to respective pages) that are using the app:
Follow the below steps to get usage information from the database 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.
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"%');
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"%');
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"%');