‎03-05-2019 11:52 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now