Get an Overview of your IP locations and LsAgent Managed Devices
To ensure you have full coverage over your network, it is good practice to create IP Range locations for your assets. This lets you group your assets based on IP so you can more easily find them and manage them. Run our report to get an overview of IP locations from the devices within your IT environment.
The report below gives you a synopsis of all your assets, their IP location and also if they have LsAgent Installed. This way you can verify that all your assets are being consistently scanned.
IP Locations Query
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
