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

chaitali1
Kilo Contributor

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 .

 

 

 

1 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

View solution in original post

5 REPLIES 5

Rahul Priyadars
Giga Sage
Giga Sage

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

find_real_file.png

 

Hope This helps

Regards

RP

 

Hi,

 

Thanks for your solution.

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

chaitali1
Kilo Contributor

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

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