Report Request: Computers missing one of two pieces of software

[kfranklin]

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.

[Daniel_B · Accepted solution]

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