How to report on links in a Confluence instance
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
For auditing purposes, you may wish to see what links are being used on each page within a Confluence instance.
Solution
Generating the report with SQL
Links are stored in the
LINKStable of the databaseEach link is attributed by a specific content ID
Each piece of content is linked to a space ID.
The following is a good starting point for generating such a report. You may need to adjust this query so it returns some more detailed information, or excludes certain types of links or spaces.
1
2
3
4
5
6
SELECT s.spacename as Space, c.title as Page, l.destspacekey as SpaceOrProtocol, l.destpagetitle as Destination
FROM LINKS l
JOIN CONTENT c ON c.contentid = l.contentid
JOIN SPACES s ON s.spaceid = c.spaceid
WHERE c.prevver IS NULL
ORDER BY l.destspacekeyUnderstanding the output
This will grab the:
Space of the page a link appears on
The title of the page a link appears on
The destination space key (or protocol, if it's an external link; such as
mailtoorhttps)The destination page title (or URL if it's an external link - note that the URL will not contain the protocol, as that's recorded in the space key column).
So you might see output like this:
Space | Page | SpaceOrProtocol | Destination |
|---|---|---|---|
DS | Welcome to Confluence | ds | Prettify the page with an image (step 4 of 9) |
TEST | Test Page | http | //www.google.com/ |
This would tell us we've got two links:
On the "Welcome to Confluence" page in the "DS" space, there's a link to the page "Prettify the page with an image (step 4 of 9)", which resides in the "DS" space
On the "Test Page" in the "TEST" space, there's a link to "http://www.google.com/"
Was this helpful?