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

npigeon
Tera Contributor

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

 

8 REPLIES 8

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

 

hanwar2_0-1693584594814.png

 

Rob Wood
ServiceNow Employee
ServiceNow Employee

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.

Hi Rob,

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

Can we talk on Teams to sort it out.

hanwar2_0-1693586133264.png

 

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