Page Comparison

...

1. The following query provides the information that how many pages are using a specific profile in 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 datasource profile name.

2. The output of

   the above query is as shown below:

   the 
   Image Modified

...