CMDB Query Builder
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12 hours ago
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.