vCenter Information

List vCenter Information

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

Click to Open - 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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting