vCenter: VMware Guest Networks (Built-in)

[Esben_D]

The report below gives back a list of vCenter Vmware guests network data.

The report will only list assets when the following criteria are met:

• You have Lansweeper 7.0 or higher.
  
• There is VMware guest data scanned.
  
• The assets must be active.

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssets1.AssetName As Host,
  tblVmwareGuestNetwork.Name,
  tblVmwareGuestNetwork.MacAddress,
  tblVmwareGuestNetwork.IpAddress,
  tblVmwareGuestNetwork.DomainName,
  tblVmwareGuestNetwork.DnsAddresses,
  tblVmwareGuestNetwork.SubnetMask,
  tblVmwareGuestNetwork.IPv6Addresses,
  tblVmwareGuestNetwork.Ipv4DhcpEnabled,
  tblVmwareGuestNetwork.Ipv6DhcpEnabled,
  tblVmwareGuestNetwork.IsConnected,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tblVmwareInfo On tblVmwareGuest.HostID = tblVmwareInfo.VmwareID
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblVmwareInfo.AssetID
  Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
    tblVmwareGuestNetwork.GuestID
Where tblState.Statename = 'Active'
Order By tblVmwareGuestNetwork.IpAddress,
  tblAssets.AssetName