vCenter ESXi Servers

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblVmwareInfo.Version,
  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,
  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