Page Comparison

...

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 as mentioned in the query.

1. For Run with a user form and parameter (Run) macro execute the below query:
   

   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 execute the below query:
   

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

   
   

3. For Hide content macro execute the below query:
   

   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="hide"%');