Flagging Unwanted Software

[MR1371]

Hello again,

After scanning through the software of some of my PC's, I've noticed some malicious software that was installed on some of them. Is there a way to make something of a report that will scan alert me when a specific software has been installed on a computer?

[Daniel_B · Accepted solution]

Either you could regularly open Reports\Software overview (one of the special reports in the right column of the Reports menu) or you build your own custom report which lists computers having specific software installed. This report could be used in a Data Report widget on your Dashboard or in an automatic email alert. Please find an example report below.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tsysOS.Image As icon
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareUni.softwareName In ('Software Example 1', 'Software Example 2')
  And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  software,
  version