Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Insight and Insight SCCM: How to get the last / newest one SCCM System object in the attribute?

Nena Kruljac
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 13, 2021

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

WeNeedTheNewestOne.jpgWithCardinality1-NotNewestConnected.jpg1EquipmentPieceWith8ConnectedSCCMObjects.jpg2EquipmenPiecesWithManyConnectedSCCMObjects.jpg

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.13.6
TAGS
AUG Leaders

Atlassian Community Events