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"%';
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
).