cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

vCenter: VMware Guest Networks (Built-in)

Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0