The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Find CIs missing either of one of the parents with specific rel type in query builder.

GChe
Giga Contributor

I am able to use No relationships to create 2 separate queries to find any CI missing a specific parent each. I am also able to use AND and get the CIs missing both parents. However when I change the AND to OR, I am getting duplicate records, with results from each of the queries in the OR. How can I find those that are missing either one of  the parents. Thanks in advance for your help.

GChe_0-1758277223243.png

 

Also, is there a way to say missing a certain type of relationship rather than missing any relationship? 

0 REPLIES 0