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...
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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