This article explains how to find pages that utilize a specific data source profile across different SQL macros in a Confluence instance. The macros involved are SQL, SQL query and SQL file.
Instructions
The following query returns information about pages that use a specific data source profile in a 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 data source profile name.
The output of the above query is as shown below:
This example is from MySQL database.