CMDB Query Builder - No Relationships - VMware Instance to Server

[Ben Draeger]

Hi all,

A bit confused around the CMDB Query Builder and looking for some advice.

I'm trying to build a report which shows VMWare Virtual Machines Instances that do not have a relationship to a Windows Server (which would be Instantiates : Instantiated by).

This is my query:

The results are a mixed big though with many still listing VMWare instances that have a relationship to a Windows server, like below:

What am I missing here, is there an additional condition that needs to be added? Or do I need to change the layout of the query? 

[Niklas Peterson]

Hi @Ben Draeger ,

Looks like your CI relationship direction is not correct for the query. The query has the Windows Server as Child but the formatter shows the Windows server as parent. Switch it around and you should be fine.

Regards,
Niklas

[Ben Draeger]

Thanks Niklas, 

I tried this, but it provided me with Windows servers that don't have a relationship to a VMware instance.

I'm looking to gather the opposite though in ServiceNow. The VMware discovery provides visibility of all of our VM's regardless of state, while discovery from Windows side might be missing records because of Ip ranges, credentials, ports blocked, turned off etc.

To help if anyone else gets stuck I ended up exporting the data from the VMware and Windows tables, then used a formula in Excel to check which records had a matching serial number.

[Niklas Peterson · Accepted solution]

Hi @Ben Draeger ,

I see. But on the topic of CMDB Query Builder, you can change the direction of the relationship, without  changing the starting node.

Regards
Niklas

[Ben Draeger]

Thanks this did the trick! I missed this option.