‎05-15-2014 10:51 PM
‎05-29-2015 09:14 PM
‎05-16-2014 11:36 PM
SELECT tsysAssetTypes.AssetTypeIcon10 AS icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen,
tblADComputers.Description
FROM tblAssets INNER JOIN
tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID INNER JOIN
tsysAssetTypes ON tblAssets.Assettype = tsysAssetTypes.AssetType LEFT JOIN
tblADComputers ON tblAssets.AssetID = tblADComputers.AssetID
WHERE (tblAssetCustom.State = 1)
ORDER BY tblAssets.Domain, tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now