VIM Virtualization Asset Summary - Is there a way to get a full list of VMs?

Question

On the VIM summary screen it gives a count of the # of VMs in the environment. Is there a way to get a list of the VMs that make up this count? I tried creating a report that lists anything that has a "Virtual Machine Node ID" but the number did not match what was listed on the asset summary page.

cgregors · Accepted Answer

Here's the sql to a report I've used. This might be what you're looking for.

select

n.caption VCenterServer,

vd.name DataCenter,

vc.name ESXcluster,

vh.hostname ESXserver,

vm.gueststate VMState,

vm.name VMguest

from

VIM_VirtualMachines vm,

VIM_Hosts vh,

VIM_Clusters vc,

VIM_DataCenters vd,

VIM_VCenters vcen,

nodes n

where

vcen.NodeID = n.NodeID and

vcen.VCenterID = vd.VCenterID and

vd.DataCenterID=vc.DataCenterID and

vc.clusterid=vh.clusterid and

vm.hostid=vh.hostid

order by

ESXserver,

ESXcluster,

DataCenter,

VCenterServer