Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

  • 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:

Code Block
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"%';

...

 
Info

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

...

  • macro:

...

    • Install a trial version of Reporting and import the storage format

...

...