→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎05-21-2020 04:47 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Version,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As Type,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon,
Case
When tblAssets.Version > '1703%' Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor,
tblADComputers.OU As [Active OU]
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress != '' And
tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tblAssets.Version,
tblAssets.IPNumeric
‎05-21-2020 05:04 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now