Generate a report of Work Items with attachments in Jira Align Enterprise Insights
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article shows how to create/get a report of Work Items containing attachments.
Solution
There is no native report nor an easy way on Jira Align UI to identify all Work Items containing attachments. It is not available through API Call as well.
At this moment, the only way to get Attachment info is via Enterprise Insights. There are tables for each Work Item that accepts attachments:
[Capability Attachment]
[Epic Attachment]
[Feature Attachment]
[Goal Attachment]
[Idea Attachment]
[Story Attachment]
[Theme Attachment]
You can run a query for a specific Work Item and then search/filter based on [FK <WorkItem> ID]:
1
SELECT * FROM current_dw.[Epic Attachment]With the data returned, a report can be generated according to your requirements.
Was this helpful?