I need a script for find out Attachment size more than 50mb for all projects in Jira?

Question

Hi Team,

I need a script or code to find out Attachment Size more than 50mb for all projects in Jira?

I am using Jira Server Instance.

Please give me your suggestions

BR,

Sattar

Gonchik Tsymzhitov · Answer

for history

select filesize /1024 /1024
from fileattachment 
order by filesize desc;

Kishan Sharma · Answer

Do you have access to database ? then below query might help as well.

select filesize from fileattachment order by filesize desc

Gonchik Tsymzhitov · Answer

Hi!

If you are on Linux you can use the next  snippet

find /{jira_home}/data -type f -size +50M