Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Creating Asset Incident Trend Reports

I'm looking for a way to create a report for my infrastructure team that shows all assets that have had 3 or more incidents linked to them in the past 6 months.

We currently pull assets from Device42 via their direct integration to JSM Premium. 

We are also exploring their integration to Jira Assets.

I can generate a list of all incidents from the past 6 months with the linked assets displayed, using something like this:

project = ITSM AND issuetype = "[System] Incident" AND created >= -26w AND "Linked assets[Assets]" != ""

However, this does not allow me to group by assets, nor even sort by assets, and if I export to Excel, I currently lose the human-friendly value of the assets listed.

Does anyone have experience working with asset data in Jira Assets pulled from a 3rd party source?

Once we have the Device42 to Jira Assets integration in place, will Jira Assets support the export and grouping I need to do?

1 answer

1 vote
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 27, 2023

@ian_silver -

Once you have migrated or integrated your Device42 and Jira Assets, what you will need is to create new custom JSM/Jira issue fields (sourced from Assets schema) and apply those fields to your JSM project issues.  After you populated those fields within your JSM issues, then your JQL will work properly.

I can only assumed that your existing custom field "Linked assets(Assets)" is a text format field?  Thus, you have difficulty in grouping your data.

Here is the reference link on custom field setup sourcing from Assets schema -

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

Thanks for the response Joseph.  We are still working through some issues with the integration.

We have been using an earlier integration that connects directly to JSM from Device42.

The Linked Assets field is not a text custom field that we created; it is part of this integration and populated dynamically via an API call.  The values DO appear in search results, but cannot be manipulated (e.g. sorted) or exported.

This is why we are exploring the newer integration to Jira Assets, hoping that we will be able to transform these into static values that we can manipulate and export.

Thanks also for the pointer on custom field setup from Assets.  

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events