vCenter ESXi Servers

List All vCenter ESXi Servers

List all the ESXi servers within your network by scanning your vCenter servers or ESXi servers directly. Lansweeper will retrieve detailed hardware information about the ESXi server as well as any guests. This overview report will show most of the hardware details, to view additional information like guest machines, you can click through to the ESXi server to view more information.

vCenter ESXi servers

Click to Open - vCenter ESXi Servers Query
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblVmwareEsxiClusters.Name As ESXICluster,
  tblVmwareDatacenters.DatacenterID,
  tblVmwareDatacenters.Name As Datacenter,
  tblAssets1.AssetName As VCenter,
  tblVmwareInfo.BiosVersion,
  tblVmwareInfo.BiosDate,
  tblVmwareInfo.BootTime,
  tblVmwareInfo.ConnectionState,
  tblVmwareInfo.CpuMhz,
  tblVmwareInfo.CpuModel,
  tblVmwareInfo.CpuPackagesDescriptions,
  tblVmwareInfo.Dhcp,
  tblVmwareInfo.EsxiClusterID,
  tblVmwareInfo.HostName,
  tblVmwareInfo.InternalKey,
  tblVmwareInfo.lastchanged,
  tblVmwareInfo.ManagementServerIp,
  tblVmwareInfo.MemorySize As MemoryGB,
  tblVmwareInfo.Model,
  tblVmwareInfo.numCpuCores As CPUCores,
  tblVmwareInfo.numCpuPkgs As CPUPackages,
  tblVmwareInfo.numCpuThreads As CPUThreads,
  tblVmwareInfo.NumHbas As HBAS,
  tblVmwareInfo.NumNics As NICS,
  tblVmwareInfo.Port,
  tblVmwareInfo.PowerState,
  tblVmwareInfo.Serial,
  tblVmwareInfo.SslThumbprint,
  tblVmwareInfo.UpTime,
  tblVmwareInfo.Uuid,
  tblVmwareInfo.Vendor,
  tblVmwareInfo.Version,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID
  Left Join tblVmwareEsxiClusters On tblVmwareInfo.EsxiClusterID =
    tblVmwareEsxiClusters.EsxiClusterID
  Left Join tblVmwareDatacenters On tblVmwareInfo.DatacenterID =
    tblVmwareDatacenters.DatacenterID
  Left Join tblVmwareVcenters On tblVmwareVcenters.VcenterID =
    tblVmwareDatacenters.VcenterID
  Left Join tblAssets tblAssets1 On tblVmwareVcenters.AssetID =
    tblAssets1.AssetID
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