Page Comparison

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

Instructions

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

Navigate to Cog wheel > General configuration

...

> Administration > Macro Usage:
Image Added
Image Added

You can see all the macro usage information like the number of pages (link redirecting respective pages) that are using the app in the Macro Usage section as shown:Image Added

Usage information using SQL queries:

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

• For the Run with a user form and parameters (Run) macro, execute the

...

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

  
  

• For the Run with a user from (Run-now) macro, execute the

...

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

  
  

• For the Hide content macro, execute the

...

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

Sample Results:

If the query returns any records, it indicates that

...

the Run Self-Service Reports for Confluence app is being used.

...

Any of the above query gives

...

a result

...

similar to:

Image RemovedImage Added