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

[Sattar Baig]

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

[Kishan Sharma]

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

select filesize from fileattachment order by filesize desc

[Gonchik Tsymzhitov]

Hi! 

If you are on Linux you can use the next  snippet

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

[Gonchik Tsymzhitov]

for history

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