Finding Confluence attachments on file system

[Paul Plunkett]

Is there an easy way to find which file(s) in the attachments directory on the file system are associated with an attachment on a page in Confluence?

[GuilhermeA · Accepted solution]

Yes there is Paul,

If you have access to the database use this, and change ATTACHMENTNAME to your actual attachmentname:

select attachmentid from attachments where TITLE like '%ATTACHMENTNAME%';

And with this you have the ID, just search for this ID in <confluence-home>/attachments/ and there should be a folder with this number (attachmentid) with a file without extention inside it, rename it and it is your file.

Cheers,

Guilherme

[twong_atlassian]

Official documentation:

https://confluence.atlassian.com/display/DOC/Hierarchical+File+System+Attachment+Storage