Page Comparison

...

Log in as Confluence Administrator and navigate to Cog wheel > General configuration > Administration > Macro Usage:

Under All macros, look out for the App name Bob Swift Atlassian Apps - Advanced Tables:

Usage information using SQL queries:

As the Advanced Tables for Confluence has five macros, you must execute the 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 json-table macro, execute the following query:
  
  

  Code Block
  language sql 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="json-table"%');

  
  

• For the table-plus macro, execute the following query:
  
  

  Code Block
  language sql 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="table-plus"%');

  
  

• For the jql-table macro, execute the following query:
  
  

  Code Block
  language sql 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="jql-table"%');

  
  

• For the attachment-table macro, execute the following query:
  
  

  Code Block
  language sql 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="attachment-table"%');

  
  

• For the csv macro, execute the following query:
  
  

  Code Block
  language sql 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="csv"%');

  
  

If the query returns any records, it indicates that the Advanced Tables for Confluence app is being used. The results are similar to:

Image Added