Notification

Icon
Error

Report on clients with no LSAgent

Posted: Thursday, February 13, 2020 12:55:11 AM(UTC)
Ozboyes

Ozboyes

Member Original PosterPosts: 7
0
Like
Hi,

Is there a way to report on all clients which doesn't have any LSAgent installed?

I am after a report which will list all clients with no LSAgent.

Much appreciate if someone can point me to right direction.
RobertB
#1RobertB Member Posts: 28  
posted: 2/21/2020 6:51:31 PM(UTC)
Why not just create a dynamic group?

RobertB attached the following image(s):
Screen Shot 2020-02-21 at 10.51.08 AM.png
RobertB
#2RobertB Member Posts: 28  
posted: 2/21/2020 6:55:32 PM(UTC)
Or if you really need a report. This is one I run to check for the agent on endpoints that have been seen in the past 30 days.

Quote:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblAssets.Lastseen > GetDate() - 30 And
tblSoftwareUni.softwareName Like '%VLC%') And tblAssetCustom.State = 1
Ozboyes
#3Ozboyes Member Original PosterPosts: 7  
posted: 2/25/2020 3:04:51 AM(UTC)
Thanks all.

I found a better version of report as:

Quote:

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,
tblState.Statename
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.State > 0
Order By tblAssets.Domain,
tblAssets.AssetName
Ozboyes
#4Ozboyes Member Original PosterPosts: 7  
posted: 2/25/2020 3:06:37 AM(UTC)
Originally Posted by: RobertB Go to Quoted Post
Why not just create a dynamic group?



Where do you create this filter? Sorry I am new to lansweeper.

Active Discussions

Lansweeper Find machines missing any 1 of several apps
by  BennettL   Go to last post Go to first unread
Last post: Yesterday at 10:15:50 PM(UTC)
Lansweeper Report on basic Router information
by  Liljack   Go to last post Go to first unread
Last post: 3/30/2020 7:44:22 AM(UTC)
Lansweeper Windows: Static IP address configured (Built-in)
by  RobinPSU   Go to last post Go to first unread
Last post: 3/27/2020 8:52:12 PM(UTC)
Lansweeper Adding top user to asset report
by  Argon0  
Go to last post Go to first unread
Last post: 3/26/2020 5:20:51 PM(UTC)
Lansweeper User Last Login (If Any)
by  Argon0   Go to last post Go to first unread
Last post: 3/26/2020 5:18:03 PM(UTC)
Lansweeper A Report to find a single file
by  Rowe  
Go to last post Go to first unread
Last post: 3/26/2020 1:38:28 PM(UTC)