Notification

Icon
Error

LSAgent Version

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

roberto.m

Member Original PosterPosts: 16
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!
Esben.D
#1Esben.D Member Administration Posts: 1,822  
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 Assets disappearing
by  Leeroy_J   Go to last post Go to first unread
Last post: Today at 12:44:56 AM(UTC)
Lansweeper Old Windows 7 Assets
by  cycleheat  
Go to last post Go to first unread
Last post: Yesterday at 9:45:35 PM(UTC)
Lansweeper Admins view all helpdesk tickets
by  thare   Go to last post Go to first unread
Last post: Yesterday at 8:50:29 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson  
Go to last post Go to first unread
Last post: Yesterday at 8:09:00 PM(UTC)
Lansweeper Change History or Restore of Custom Reports?
by  GoHawks5   Go to last post Go to first unread
Last post: Yesterday at 4:20:52 PM(UTC)
Lansweeper agents can't create new tabs
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 3:51:07 PM(UTC)
Lansweeper Schedule/Calendar Ticket
by  enush   Go to last post Go to first unread
Last post: Yesterday at 3:46:21 PM(UTC)