‎06-24-2014 06:11 PM
Solved! Go to Solution.
‎06-25-2014 03:50 PM
‎06-25-2014 03:50 PM
‎06-25-2014 11:14 AM
‎06-25-2014 12:29 AM
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
FROM
tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
tblAssetCustom.State = 1
AND tblAssetCustom.Location = ''
AND tsysAssetTypes.AssetType = -1or
AND tsysAssetTypes.AssetTypename = 'Windows'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now