How to track Redirection app usage?

Purpose

To track the usage of the Redirection for 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"%'; 

For more information on the SQL query, read How to find all pages and spaces that use a specific macro via SQL.

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).