How can I query Assets (Insight) in JSM to find the previous owner (assignee) of an asset?

[Kalin U]

Hello, community.

I'm trying to find the previous owner (assignee) of a workstations that we track in Assets. We use an attribute "Assigned to" in objects "Workstations". The attribute on its end refers to an object of type "Users".

When I open the "Activity" tab of a workstation, I can see the previous values of "Assigned to". However, I want to find all workstations that at some point were assigned to a specific user. Or find all users that were assigned to a specific workstation. Is that possible?

I could not find an operator "WAS" in AQL (IQL), similar to the one in JQL, that surfaces objects (or issues in the case of JQL) that had a specific value in the past.

[Dirk Ronsmans · Accepted solution]

Hi @Kalin U ,

Sadly it's not yet possible to use a WAS operator in AQL. They are tracking a suggestion about it tho here https://jira.atlassian.com/browse/JSDCLOUD-10768

I suggest adding your vote to the issue and adding yourself as a watcher to be notified of any changes.

[Kalin U]

Thanks for tip. Do you know any workaround besides manually checking the "Activity" tab?

[MF · Accepted solution]

A workaround could be:

Query ALL objects (to get the ids) and then a query loop to gather all history data via https://developer.atlassian.com/cloud/assets/rest/api-group-object/#api-object-id-history-get then you can iterate over all data to filter the searched User...

[MF]

If you cache the history data and just check for not cached objects its a little less expensive...