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

...

Follow the below steps to get the usage information from the database using the SQL queryin the Macro Usage section as shown:Image Added

Usage information using SQL queries:

As the Run Self-Service Reports for Confluence is having two  has three macros, you must execute the below two 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