Hi I was hoping i could get some help.
I am trying to get all our VM's with what host and cluster they are on for use importing into a CMDB.
So far i think i found the info in the tables but don't know how to link that into a single query that provides the 3 things.
SELECT ClusterID,HostID,.GuestDnsName, GuestState FROM Orion.VIM.DataCenters,Orion.VIM.Clusters,Orion.VIM.Hosts,Orion.VIM.VirtualMachines