Report on clients with no LSAgent

[pranavsinha]

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.

[pranavsinha]

Thanks all.

I found a better version of report as:

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

[RobertBasil]

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.

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

[RobertBasil]

Why not just create a dynamic group?

[pranavsinha]

RobertB wrote:
Why not just create a dynamic group?

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