The CreatorCon Call for Content is officially open! Get started here.

CMDB Query Builder

nathanpalin
Tera Contributor

Hello,

 

I am building a query that returns all Computers (Computer 1) with particular Software Instances (Software Instance 1) installed on them, where those same Computers are also related to a System (System 2, a user table). I would also like returned, those same Computers that have the same Software Instances installed on them but are NOT related to a System.

As I cannot have a node connected to the same node twice, I have added the Software Instance 4 and System 6 nodes, where Software Instance 4 matches Software Instance 1 and the connector from Computer 1 to System 6 has No Relationships.

 

My thinking is: after the OR operator, I want to combine the connectors to Software Instance 4 and System 6 to create another AND operator. But I cant seem to make this happen. When I'm connecting nodes from Computer 1 or the OR operator, it will always handle them separately.

 

Advice would be appreciated! Thanks.

0 REPLIES 0