In Jira Assets, is there a way to create an AQL query or report on multiple inbound references

[Michael Frade]

Looking to create a query, automation or report that would return any Employees who have more than 1 Laptop assigned to them in Jira Assets.

Have an Employee object type  that would have inbound references from a Laptops object type.

The Laptops object type has an attribute of Assigned To that points to the object type of Employees.

You can see in the object view of an Employee if the have multiple references coming in. Have not been able to find a way to just query for those with multiple assignments currently

Appreciate any tips or feedback

[Josh]

@Michael Frade it looks like you might be able to accomplish something like this using JSM Automation:
How to use list functions (like size, average) on Assets object attributes in Automation

[Michael Frade]

I saw that article, problem being the lookupobjects action limits 100 items to be returned.  Have worked around that in the past in other scenarios but was really looking to trying and get just the users who have multiple assignments to them. Or even the opposite end where it would look at the laptop and see who has their name in the assigned to attribute more than once.

[Josh]

@Michael Frade I haven't personally tested this yet, but the new "create dynamic lookup table" automation action may be part of a better solution for you:

New Automation action - Create dynamic lookup tabl... - Atlassian Community

Wondering if instead of performing the AQL lookup, you could connect to the Assets API and then create a dynamic table with the results...

The Assets REST API

[Christopher Yen]

Unfortunately I don't think AQL has this functionality yet. Right now if this report were requested from me I would work off an export in excel or google sheets. 

[Michael Frade]

That is the alternative I have been working with but was hoping I was missing something somewhere.