VMware Virtual Guest Machines Overview
By scanning your vCenter appliance servers or ESXi server directly, Lansweeper retrieves detailed information about your VMware guests. Information such as the host, it's version, memory assigned and state are all included in this overview report. Find and view all VMware guests in your environment. To find more information about the guest machines, you can navigate to the guest's page to view more detailed information about its hardware and software.
VMware Virtual Guest Machines Query
Select Top 1000000 ha.AssetID, tblVmwareGuest.Name As Guest, ha.AssetName As Host, h.Version, tblVmwareGuest.Memory, tblVmwareGuest.IsRunning As State, tsysAssetTypes.AssetTypeIcon10 As icon, tblVmwareGuest.lastchanged, tblAssets.Domain, tsysAssetTypes.AssetTypename As Type, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID Inner Join tblVmwareInfo h On tblVmwareGuest.HostID = h.VmwareID Inner Join tblAssets ha On ha.AssetID = h.AssetID Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Left Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Order By Host, Guest