‎02-14-2017 03:14 PM
‎02-16-2017 02:31 PM
Select Top 1000000 tblAssetCustom.Custom1 As FullName,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysOS.OSname,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.Lastseen,
tsysIPLocations.IPLocation,
tblAssets.IPAddress As IP
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.IPAddress <> '' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now