Community
Q&A
Confluence
Questions
How to find confluence page with all the big attachments?

How to find confluence page with all the big attachments?

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!

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

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;

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Confluence

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How to find confluence page with all the big attachments?

3 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events