Modify Report, all computers without antivirus to exclude computers with Wesxxxxxxxx

[NOGEHR]

Would like to modify the report, to exclude our Wes terminals. Wes being the computer name.

How would I go about modifying the canned report to do this?

[NOGEHR]

Thank you,

I was able to modify the report to obtain the information I needed.

[Daniel_B · Accepted solution]

In order to exclude specific asset names or parts of it from a report, edit the report, look for tblAssets.Assetname and add a filter criterium to it. The following report uses the criterium "Not Like 'wes%'":

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetName Not Like 'wes%' And tblAssetCustom.State = 1