Page Comparison

...

Purpose

To track the usage of the Redirection for the Confluence Server app throughout the Confluence instance.

Answer

Here are some solutions to track Redirection’s macro usage:

Using Confluence macro

• Use Confluence’s Macro Usage feature to track Redirection macro usage:

  • In Confluence, go to Settings > General Configuration > Macro Usage.

Using SQL query

• Use the SQL query below to track all pages using Redirection macro:

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

Using Reporting app

• Use our Reporting for Confluence Server app to list all the pages that contain a macro:

  • Install a trial version of Reporting and import the storage format shown in the Searching Confluence Pages for a Specific Macro article.

  • Change the Text Filter Contains Value parameter to the macro that you want to search for (eg. redirect).