Skip to end of banner
Go to start of banner

How to get usage information about Run Self-Service Reports for Confluence app

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

The below article helps you to get the usage information of the Run macros that are in a Confluence page:

Instructions

  1. Navigate to General configuration from the cogwheel:
  2. Navigate to Macro Usage from Administration on the left side panel:
  3. 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.

  1. 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"%');
  2. 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"%');
  3. 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"%');


  • No labels