Find All LsAgent Versions Used
LsAgent is Lansweeper's agent-based scanning method designed for scanning hard-to-reach devices or machines which have strict network security protocols. Additionally, it can be used to scan remote machines with ease so your inventory does not stop when your LAN network does.
The audit below provides you a list of all assets which are scanned using LsAgent along with the version of LsAgent used to perform the scan. Windows LsAgent installations are updated automatically. For Linux and Mac, this audit lets you easily check whether the LsAgent version used is the latest one available, and update if needed.
LsAgent Version Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblassets.LsAgentVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblState.Statename = 'Active' and tblassets.LsAgentVersion IS NOT NULL
Order By tblAssets.Domain,
tblAssets.AssetName
