Notification

Icon
Error

Report on clients with no LSAgent

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

Ozboyes

Member Original PosterPosts: 4
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: 25  
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: 25  
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

Active Discussions

Lansweeper Report on clients with no LSAgent
by  RobertB   Go to last post Go to first unread
Last post: Yesterday at 6:55:32 PM(UTC)
Lansweeper Lansweeper report to match computer name
by  RC62N   Go to last post Go to first unread
Last post: 2/19/2020 5:02:27 PM(UTC)
Lansweeper Distinct user logins per PC
by  Bruce Garoutte   Go to last post Go to first unread
Last post: 2/17/2020 6:36:29 PM(UTC)
Lansweeper Software version report issue
by  RC62N  
Go to last post Go to first unread
Last post: 2/17/2020 4:07:20 PM(UTC)
Lansweeper Patch Tuesday - Exclude Win 2008 & Win7
by  doone128   Go to last post Go to first unread
Last post: 2/17/2020 1:34:36 PM(UTC)
Lansweeper Performance statistics combined into one report
by  djs1789  
Go to last post Go to first unread
Last post: 2/15/2020 1:50:32 AM(UTC)