Query for Total Attachment Size - JIRA

MJ June 22, 2022

I am trying to find a MSSQL query to identify the total size of attachments in a Jira instance. Any insight appreciated. Thanks!

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 22, 2022

There is no way to do that.  SQL is the worst possible way to try to report on Jira data, and you've hit one of the thousands of reasons that it is that it is so bad.  The database doesn't bother to record that data.

Try running "du -d1 /<jira home>/attachments" on your Jira server, that will get you a starting number.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events