IQL in Insight

[tomas nicolas boltin]

Hello Atlassian community! I wanted to ask about this issue and I am not being able to find a solution. In Insight I have a type of object called "AWS" and within it (As seen in the image) there are different types of objects such as "Load Balancer", " General", "Compute", "RDS" or "Workspaces". What I don't know is how to retrieve these types of objects using an IQL query in insight. I tried all the operators there are and I can't get them.

I wait an answer! Thank you so much

[Jeroen Poismans · Accepted solution]

Hi Thomas,

Have you tried this?

objectType in objectTypeAndChildren("AWS")

Hope this helps!

[tomas nicolas boltin]

First, thank you very much for responding! I think it works, what I would like to know is if there is an operator that only returns each object once, according to the image I attached I would like it to return "Load Balancer", "General" and so on with all of them.

[Jeroen Poismans]

An IQL returns objects, not object types. Not sure what you're trying to do, can you elaborate with an example of the output you're after?

[tomas nicolas boltin]

Obvious. I would like to make a query in IQL that returns all the types that are contained, in this case in AWS, that is to say that they appear: "Load Balancer", "General", "Security Group", "Compute", "Management & governance ", but only once each. Since the query in the first response brings me all of each type and I only need one of each of the object types.

[Jeroen Poismans]

The IQL I provided gives you all the objects in all the objecttypes that are AWS or one of it's children. You can't have IQL return the object types themselves, only the objects.

[tomas nicolas boltin]

Aaahh perfect! Thanks a lot, Jeroen.