Insight and Insight SCCM: How to get the last / newest one SCCM System object in the attribute?
Hi,
Question: How to get the last / newest one SCCM System object in the attribute?
Settings:
- Jira Software 8.13.6
- JIRA Service Desk 4.13.6
- Insight 8.7.10
- Insight SCCM Integration: 1.6.2
Situation:
I imported hardware equipment to Insight from CSV file. One of the attributes is SCCM object type System. There are some pieces of equipment with many connected SCCM objects - 7-8.
- Object type name: "Reboot1 Hardware Asset v1"
- Attribute name: "SCCM details - System"- Cardinality - Maximum: 1
- Control (only temporary) attribute: "SCCM details - System N" - Cardinality Unlimited - just to quickly check all connected SCCM objects and find the newest one (only for testing purpose)
I tried with Filter by IQL on the attribute, but it didn't help:
- order by created DESC
- order by "Creation Date" DESC
I've read this documentation, but didn't find anything relevant: https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/
I can't use Status attribute, because the newest / last one isn't always Running - it's sometimes among the inactive statuses.
Example data:
- Hardware asset object NB-516023 TIAPBIS-1431280 has 8 SCCM objects (they are all in "SCCM details - System N" attribute) - the newest one TIAPBIS-1255773 is created on 25.07.2021 01:00 - we need this to be retrieved
- In "SCCM details - System" is object is TIAPBIS-1221970, that is created on 15.05.2021 01:00
- Instead of the newest one: TIAPBIS-1255773, that is created on 25.07.2021 01:00
Thank you, kind regards, Nena
