By scanning your vCenter appliance servers, Lansweeper retrieved detailed information about your VMware environments. Information such as operating system, version, build and locale version are all included in this overview report. Find and view all vCenter servers in your environment. To find more information about the vCenter servers, you can click through to the vCenter’s page to view information like the managed ESXi servers.
vCenter Information Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblVmwareProductInfo.Vendor,
tblVmwareProductInfo.OsType,
tblVmwareProductInfo.ProductLineID,
tblVmwareProductInfo.Version,
tblVmwareProductInfo.ApiType,
tblVmwareProductInfo.ApiVersion,
tblVmwareProductInfo.Build,
tblVmwareProductInfo.FullName As Description,
tblVmwareProductInfo.InstanceUuid,
tblVmwareProductInfo.LicenseProductName,
tblVmwareProductInfo.LicenseProductVersion,
tblVmwareProductInfo.LocaleBuild,
tblVmwareProductInfo.LocaleVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblVmwareVcenters
Inner Join tblAssets On tblAssets.AssetID = tblVmwareVcenters.AssetID
Inner Join tblVmwareProductInfo On tblVmwareVcenters.VcenterID =
tblVmwareProductInfo.VCenterID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
Order By tblAssets.IPAddress,
tblAssets.AssetName
