You can run this query against your Confluence database to find all of the external links:
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 and l.destspacekey in ('http','https')
ORDER BY l.destspacekey;
To filter for a particular space, add a where clause to filter based on the s.spacename column.
Update for Confluence 6.10
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 and l.DESTSPACEKEY in ('http','https')
ORDER BY l.DESTSPACEKEY;
In that case you would need to create a script that goes through the content of each page looking for links. I do know that external links have a CSS class applied to them called ".external-link". You can just search the content of a page for anything that has that class and that should give you a list of external links.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs