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

[Amit Gujarathi]

HI @npigeon ,
I trust you are doing great.

1. First, create a new report in ServiceNow by navigating to the "Reports" module.

2. Select the appropriate table from which you want to fetch the data. In this case, you can choose the "cmdb_ci_vmware_instance" table, which contains information about VMware virtual machine instances.

3. Add the desired columns to your report. You can include the following columns: VM name, host, cluster, CPU, and cores. To add these columns, click on the "Add/Remove Columns" option in the report builder and select the corresponding fields from the available choices.

4. Apply filters to display only Windows servers with SQL. To do this, click on the "Add Filter" option in the report builder. You can add a filter based on the operating system and the presence of SQL software on the server. For example, you can set the filter conditions as "Operating System contains Windows" and "Software Name contains SQL Server."

5. Once you have added the necessary columns and filters, you can run the report to see the results. Click on the "Run" button to generate the report.

6. You can export the report to various formats like CSV or Excel by using the "Export" option in the report viewer.

[npigeon]

Hi Amit, thanks for the reply.

I created a report based on the 'cmdb_ci_vmware_instance' table and added columns for host and cluster but these return empty data. Is it because we don't have any data working in those tables ?

Thanks

Nicolas

[Rob Wood]

You can get guest, host and cluster via CMDB Query Builder.

[Cons Austria]

Thanks!