How to find all pages that link to a specific attachment?

[Tom Birch Hansen]

I have several pages with dublicated attachments. But how do I find out which attachments haven't got any incomming links? In other words how do I find pages that link to a specific attachment?

[Samuel Patrice Rompas [Atlassian]]

Hi Tom,

This can't be done through Confluence UI yet. If you have access to the database, you can run this query to find the page/blog that link to specific attachment:

select s.spacename, c.title, c.contenttype from content c inner join spaces s on c.spaceid = s.spaceid where c.contentid in (select contentid from bodycontent where prevver is null and body like '%filename="filename.ext%');

Change the filename.ext to the name of attachment (e.g.: README.txt).

Regards,
Samuel

[Tom Birch Hansen]

Thank you for your reply. I do have database access, but the query you suggest will not work as there are likely to be many pages in a space with attachments with same filename, for instance 'readme.txt'.

Also a sql query is not very applicaple for the average confluence users.

Do you know if there is a JIRA request to fix this?

It seems odd that links to attachments are not listed on the 'page information' page, and that you get no warning when deleting a page if there are other pages with links to attachements on the page being deleted.

[Helen Gosper]

@Samuel Patrice Rompas [Atlassian]'s reply back in 2014 mentioned this can't be done through Confluence UI yet - is this feature on the Roadmap? It would be very useful to be able to display a list of all the pages in a space that link to a specific attachment - for example, via an 'incoming links' information section, perhaps under 'Properties'.

The use-case would be to see at a glance which pages an image has been used on. This would save time in my situation when updating screenshots in technical documentation. Thanks