How to track Redirection app usage?

Owned by

Last updated: Sept 15, 2023 by

Julver Petrova (Deactivated)

1 min read

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