Notification

Icon
Error

LSAgent Version

Posted: Tuesday, August 13, 2019 3:33:50 PM(UTC)
roberto.m

roberto.m

Member Original PosterPosts: 17
0
Like
How can I know the LSAgent version I have currently running on my macOS?

I need this info to see if a newer version is available.

Thanks!
Charles.X
#1Esben.D Member Administration Posts: 1,933  
posted: 9/3/2019 3:38:33 PM(UTC)
This is actually stored in the Lansweeper database in tblassets.LsAgentVersion.

The report below shows all LsAgent scanned assets along with the version used.

Code:
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

Active Discussions

Lansweeper Physical Disk Size
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 5:18:38 PM(UTC)
Lansweeper AD User report
by  GMcCartney  
Go to last post Go to first unread
Last post: Yesterday at 12:07:22 PM(UTC)
Lansweeper PC Build Report Missing Software
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 10:28:40 AM(UTC)
Lansweeper Creat report ALL office (ms officce,libreoffice,openoffice)
by  RC62N  
Go to last post Go to first unread
Last post: 11/15/2019 9:58:33 PM(UTC)
Lansweeper How to Report on Dynamic Asset Groups
by  Rob-CD   Go to last post Go to first unread
Last post: 11/15/2019 11:49:22 AM(UTC)
Lansweeper Custom All Assets Report Help
by  Matt Fuhrman  
Go to last post Go to first unread
Last post: 11/14/2019 3:55:25 PM(UTC)
Report Center Calculate your network's computing power
by  GBInnovation   Go to last post Go to first unread
Last post: 11/13/2019 12:11:18 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  JacobH  
Go to last post Go to first unread
Last post: 11/12/2019 5:28:37 PM(UTC)