How to find all spaces and pages which use Latex Math macros

This article applies to the Data Center version of the app

This article helps you find all the spaces and pages where the Latex Math for Confluence macros are added to your Confluence instance hosted on the Data Center.

Instructions

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 relevant pages.

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"%'

Results:

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 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.