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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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