IP Location Overview

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress As IP,
tsysIPLocations.IPLocation,
Case
When tblAssets.AssetID = subquery1.AssetID Then 'Yes'
Else 'No'
End As [LsAgent Installed],
tblAssets.AssetID,
tblAssets.Lastseen
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
Left Join (Select Top 1000000 tblAssets.AssetID,
tblAssets.LsAgentVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.LsAgentVersion Is Not Null And tblState.Statename =
'Active'
Order By tblAssets.Domain,
tblAssets.AssetName) As subquery1 On subquery1.AssetID =
tblAssets.AssetID
Where tsysAssetTypes.AssetTypename NOT IN ('Location','Monitor') And
tblAssetCustom.State = 1
Order By tblAssets.IPNumeric