This article explains how to find pages that utilize macro to a specific profile using SQL for Confluence app.
Instructions
The following query provides the information that how many pages are using a specific profile in Confluence instance.
SELECT c.contentid, c.contenttype, c.title, s.spacekey FROM CONTENT c JOIN BODYCONTENT bc ON c.contentid = bc.contentid JOIN SPACES s ON c.spaceid = s.spaceid WHERE c.prevver IS NULL AND c.contenttype IN ('PAGE', 'BLOGPOST') AND bc.body LIKE '%ac:name="dataSource">Profile_name%';Note: Replace Profile_name in the query with your datasource profile name.
The output of the above query is as shown below:
This example is from the MySQL database.