Extract List of lage attachments Tickets

Question

We are currently exceeding 2GB limit in JIRA and would like to get a "List of JIRA Tickets with largest files" This will enable us to clean up for some space.

We were assisted last time by an Altassian support staff as the information can only be retrieved from the backend database which is only accessible by Altassian staff.

However this time we are being asked to check with the Community .

Is there any way to extract this "List of JIRA Tickets with largest files" on our own.

Please advise.

Teena George

Angélica Luz · Answer

Hello @Teena,

Thank you for reaching out to Atlassian Community!

In Jira Cloud, currently, it’s not possible to access such details in the UI.

There is a feature request suggesting the implementation of this ability:

Ability to manage existing attachments in the instance

As you mentioned, it’s possible to see in the database and we can only access it if a ticket is created because we need the admin’s consent through the ticket (Standard and Premium plans). This option is not available here in Community.

As a workaround, you can create a backup (Cog icon > System > Backup manager) and check the option to include attachments. After you unzip the folder, on the folder Data > Attachments you will see the Project Key, and expanding each folder you will see the Issue Key, and expanding it will show the attachment ID and size.

Hope this helps!

If there is anything else we can help you with, please let us know.

Kind regards,
Angélica

Brant Schroeder · Answer

@Teena

I do not know of any way to do this in cloud via JQL.  I can escalate to Atlassian for you to see if they can pull this for you again.  I would suggest that you consider upgrading to a payed plan you get additional features and substantially more space.