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.

...

This article explains how to get a list of Confluence pages and their respective spaces where the Run Self-Service Reports for Confluence 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. If the query returns any records, the output includes the Title of the page and SpaceID of the relevant pages.

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

  
  

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 Added