I have migrated attachment from database to file system on Confluence 5.8.x.
Now I need a query to sum the size (Gb) of all attachment from current version ?
Can I query this now they are on file system ?
Thanks for any help.
I tried this query:
select sum(filesize) from attachments
But it will take everything from the attachments table such as the other attachments versions. I'm also not sure how you could convert it to GB .
Also: In Confluence 5.8 the attachments are stored in the content table, if I'm not wrong...
Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...
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