How to get VM, Host and Cluster relationship all in the same report ?

[npigeon]

Hey all!

I'm new to Service Now and I've been trying to create a report that contains the VM name and on which host and cluster it's on with their CPU and Cores. For example, I want to do it for all my Windows server for SQL.

I've been looking at Windows and SQL infrastructure report, cmdb_sw_install and cmdb_rel_ci but it does not tell me much of what I need.

Thanks

[Community Alums]

Hi Rob,

I am trying to create a report which shows the Cluster to ESX Host mapping. I tried to use CMDB Query Builder and attaching the same but it looks its not complete. can you please help

[Rob Wood]

It looks like you are missing the ESX Server to Cluster relationship.  You're going straight from ESX Server to VCenter.  I know it's a bit confusing and non-intuitive at first.  See the attached screenshots.

[Community Alums]

Hi Rob,

I made the changes but the report is coming as blank.

Can we talk on Teams to sort it out.

[Community Alums]

Hi Rob, It would be great if you can guide me.