Can i get list of all attachments and the size of the attachment

[mani@123]

Hello All,

I am trying to determine the distribution of file size across all the attachments.  For example,  number of files less than 1MB, between 1MB and 10MB and between 10MB and 50 MB.

Is it possible?

Thanks in Advance,

Mani

[Payne · Accepted solution]

If you or perhaps a DBA within your company has access to the database, a simple query like the following will give you that information. I generally advocate against directly accessing the database, but an occasional query like this I say is OK.

select filesize from fileattachment order by filesize desc

[mani@123]

Thanks Payne! I can see all attachments size in DESC order.

Thanks Again,

Mani

[Payne]

You can do a select *; there are only 9 columns, and none are BLOBs

SELECT * FROM fileattachment

[Alexey Matveev · Accepted solution]

Hello,

You can not do it out of the box. You can either have a look at the jira_home/data/attachments folder and write a script to get the data, you need, or you can use Jira API to get the same info. But in any case you would need to develop a script.

[Aleksandr Duk]

It's JIRA home. Where should I look for "data"?

[Alexander Pappert]

you can use Excel power query, to get Information About Name, size, … from a specific folder

https://www.mssqltips.com/sqlservertip/4022/retrieve-file-sizes-from-the-file-system-using-power-query/

[mani@123]

Hi Alexander,

Thanks for the reply!

How do i connect powerquery to the centos server? I didn't find any documentation online.

Thanks in Advance,

Mani

[Alexander Pappert]

Install the power query addon in ecxel
then, as in my link above,:
-> Power Query ribbon, go to the section Get External Data, click on From File and then navigate to From Folder

You Need access to the jira-addon folder