→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kfranklin
Engaged Sweeper
We are pushing out ESET Endpoint Antivirus to all of our machines ( about 750 installs) and need to ensure that both the Admin Agent and the actual AV Client are installed. I have a report of machines that have one or the other, but the numbers are off by about 5 machines. What I'm looking for is either a report that shows every machine with their respective agent/client software versions installed, or a report that shows just the machines that are missing either the agent or the client. Could even use two reports that show machines with the agent but not the client or machines with the client but not the agent. Any help would be appreciated.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
You can do this through a software report in which you enter a filter on tblSoftwareUni.softwareName. Please find an example below. You need to adapt the software name filtered for to the real software name as it was scanned on your network.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
Coalesce(tSoftwareESET.softwareName, 'none') As softwareName,
tSoftwareESET.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'ESET admin agent %') Or
(tblSoftwareUni.softwareName Like 'ESET AV client %')) tSoftwareESET
On tSoftwareESET.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.AssetName,
tSoftwareESET.softwareName

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
You can do this through a software report in which you enter a filter on tblSoftwareUni.softwareName. Please find an example below. You need to adapt the software name filtered for to the real software name as it was scanned on your network.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
Coalesce(tSoftwareESET.softwareName, 'none') As softwareName,
tSoftwareESET.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'ESET admin agent %') Or
(tblSoftwareUni.softwareName Like 'ESET AV client %')) tSoftwareESET
On tSoftwareESET.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.AssetName,
tSoftwareESET.softwareName