How to create new report for Vcenter which contain name of VM machine.

[chaitali1]

Can somebody guide me with exact step-

How to create new report in CMDB for list of VCenter with virtual machine name.

Means we can able to see which CCenter  is associate with VM machine .

[Rahul Priyadars]

There is no direct data connect between Vmware Vcenter instance and Virtual Machine Instance.

You need to traverse using script or play in XLS.

(1) Vcenter has data center CIs- its connected using managed by : Manages

(2) Data center has ESX 

ESX Server [cmdb_ci_esx_server]

Contains:Contained by

Datacenter [cmdb_ci_vcenter_datacenter]

(3) Vm Instances are connected with ESX using below relationship

VM Instance [cmdb_ci_vmware_instance]

Registered on:Has registered

ESX Server [cmdb_ci_esx_server]

So either you can write script to make a direct report for Vcenter having which all Vm instances

or fetch 3 report in XLS and play in XLS to produce the required report.

Below relationship diagram can help you in data traversal

Hope This helps

Regards

RP

[chaitali1]

Hi,

Thanks for your solution.

We can't create report direct in cmdb reports using condition.

[chaitali1]

How to fetch 3 report in XLS and play in XLS to produce the required report.

[Rahul Priyadars · Accepted solution]

It works like Common Columns between (like Keys) between 3 XLS and then Merge finally using Pivot of XLS macro to get the output.

Regards

RP