Page Comparison

...

1. The following query returns information about pages that use a specific data source profile in a Confluence instance.

   Code Block
   theme Midnight
   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.

2. The output of the above query is as shown below:
   Image RemovedImage Added

...