
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2015 05:12 PM
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2015 01:32 PM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2015 01:32 PM
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
