Content Comparison

Overview

This article explains how to get retrieve the usage information like the Confluence page titles, spaces, etc. where the HTML macros are used. 

Instructions

Usage information through database query:

Run

...

the following query in your database

...

:

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="html"%';

If the query returns any records, it indicates that

...

the HTML macro is being used and it displays the page title as

...

: 

Image Modified

Usage information through SQL for Confluence

...

:

Alternatively, if you have the the SQL for Confluence app  app installed in your Confluence instance, you can execute run the above mentioned query directly on the Confluence page using the SQL macro and return , which returns the following results: 

Image Modified