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 Changes in the licensing model
by  BullGates   Go to last post Go to first unread
Last post: Yesterday at 7:30:32 PM(UTC)
Lansweeper About Memory Changes
by  fjca  
Go to last post Go to first unread
Last post: Yesterday at 5:51:17 PM(UTC)
Lansweeper Wildcard in file scanning to get all files in a directory?
by  RKCar   Go to last post Go to first unread
Last post: Yesterday at 4:03:43 PM(UTC)
Lansweeper Wishlist is dead, no responses from LS staff.
by  RobertB  
Go to last post Go to first unread
Last post: Yesterday at 3:08:12 PM(UTC)
Lansweeper Deploy installer packages not working any more
by  richv   Go to last post Go to first unread
Last post: Yesterday at 3:06:19 PM(UTC)
Lansweeper File Scanning
by  RKCar  
Go to last post Go to first unread
Last post: Yesterday at 2:22:54 PM(UTC)
Lansweeper HP Warranty scan - broken for some products
by  zaty   Go to last post Go to first unread
Last post: Yesterday at 1:52:38 PM(UTC)
Lansweeper How to stop deployments ?
by  Leandro Martins  
Go to last post Go to first unread
Last post: Yesterday at 1:47:22 PM(UTC)