CMDB Query Builder – Find Business Applications with NO Business Capability relationship

[dd31]

Hi team,

I'm trying to build a CMDB Query Builder query to identify Business Applications that are not related to any Business Capability.

Current setup:

• Starting node: Business Application

• Connected to: Business Capability

• Relationship: No Relationships

• Direction: Parent = Business Application, Child = Business Capability

This works only for one direction. However, relationships in our CMDB may exist in either direction:

• Business Application → Business Capability

• Business Capability → Business Application

When I try to add another reversed relationship, Query Builder throws error:
"The query graph is not valid: A not Connector node can be connected only to a leaf node"

Questions:

1. How can we check no relationship in both directions in CMDB Query Builder?

2. Is there a way to use AND with two "No relationship" conditions?

3. Is Query Builder capable of this, or should this be done via report / database view?

Goal:
Return all Business Applications that have no relationship at all with Business Capability.

Thank you!

[CasperJT · Accepted solution]

Hi,

Have you tried with an OR branch? 

On the relationships from Business Application 1 to Business Capability 1 I have set parent as Business Capability 1 and "No relationships". 

On the relationships from Business Application 1 to Business Capability 12 I have set parent as Business Application 1 and "No relationships". 

This will also work with an AND branch. Keep in mind OR will return any business app that is missing either while AND will only return business apps that are missing both.

 

Hope this helps.

//CasperJT