Page Comparison

...

• Log in as Confluence Administrator and navigate to Cogwheel > General configuration > Administration > Macro Usage:

...

• Under All macros, look out for the App name Latex Math:

...

Usage information using SQL queries

...

Use the following query to get the macro-level usage information. If the query returns any records, the output includes the Space Key, Space name, Title of the page of the relevant pages.

Code Block
language sql
SELECT DISTINCT SPACES.SPACEKEY, SPACES.SPACENAME, CONTENT.Title, BODYCONTENT.body FROM BODYCONTENT JOIN CONTENT ON BODYCONTENT.CONTENTID = CONTENT.CONTENTID JOIN SPACES ON CONTENT.SPACEID = SPACES.SPACEID WHERE BODYCONTENT.BODY like '%<ac:structured-macro ac:name="mathblock"%' OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathblock-ref"%' OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathinline"%' OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathblock-table"%' OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="unit"%' OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="latex"%'

...

Info
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 is used. Run the query during off-business hours to reduce any impact caused by the query's run time. Queries have to be adjusted with syntax in databases.

...