How to find confluence page with all the big attachments?

[DI2E Licensing]

I know all the big attachments are in this directory:

/opt/atlassian/confluence-data/attachments/ver003/113/1/4751363/73/142/17892323/18187909

How do I translate that into a specific confluence page?

Thanks!

[Don Willis · Accepted solution]

As (sort-of) described in the document Bruna linked to, the url you want to find the page with the attachment in your example is:

http://yourconfluencebaseincludingcontextpath/pages/viewpage.action?pageId=17892323

Note that 17892323 is the second-last directory in your path

However a better answer to your wider problem is probably the one at: https://answers.atlassian.com/questions/195387/how-can-i-find-very-large-attachments

[Bruna Griebeler]

Hi there,

You might try to find the PageID related to that attachment by checking the attachments table on Confluence database.

To undesrtand what does this path means:

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

https://confluence.atlassian.com/download/attachments/179442774/attachmentstorage.png?version=4&modificationDate=1234484336367&api=v2

Displaying Attachments:

https://confluence.atlassian.com/display/DOC/Displaying+a+List+of+Attachments

To retrieve an Attachment from FileSystem:

select s.spaceid,c.contentid,a.attachmentid from spaces s inner join content c on s.spaceid=c.spaceid inner join attachments a on a.pageid=c.contentid;

[DI2E Licensing]

Thanks to both. I actually went in to the database and using that nice pictorial supplied by Bruna, found the name of the project and doc(s) I was looking for.

BUt I love the meta-searches that Don pointed me to.