→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-04-2018 08:09 PM
‎04-06-2018 02:08 PM
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress As [Host IP],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets1.AssetID As [Guest Asset ID],
tblVmwareGuest.Name As [Guest Name],
tblAssets1.AssetName As [Guest AssetName],
tblAssets1.IPAddress As [Guest IP],
Case When (tblAssets1.AssetName Is Null) Then 'Not Scanned' Else 'Scanned'
End As [Scan Status]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblVmwareGuestNetwork.MacAddress
Left Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Order By tblAssets.AssetName
‎04-05-2018 05:43 PM
‎04-05-2018 04:48 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now