How to get the app usage for Advanced Tables for Confluence
This article helps you get the list of pages where the Advanced Tables for Confluence macros are added to your confluence instance hosted on the server or data center.
Instructions
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:
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:
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:
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:
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:
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:
It is recommended to:
- Test the above queries in a test environment. The time taken to get the results is based on the number of pages where the macro has been used.
- Run the query during the off-business hours to reduce any impact caused due to the run time of the query.
- Queries have to be adjusted with syntax in databases.