Exclude Specific Asset Groups from Reports

[WhatTheFrenchTo]

I'd like to exclude specific asset groups from certain reports is there a quick way in the GUI to do this? If so, I haven't come across the option yet. Your help is greatly appreciated. The reason for this is because I have some VMs/Servers that are reporting no AV though I don't want AV on them in the first place.

[RCorbeil · Accepted solution]

Run yourself a list of what's in tblAssetCustom.

SELECT Distinct Top 1000000
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model
FROM
  tblAssetCustom

You should be able to use what you find in there to filter on the manufacturer and/or model. E.g. with my inventory, I can include

  AND (tblAssetCustom.Manufacturer Not Like 'VMWare%')
  AND (tblAssetCustom.Model Not Like 'VMWare%')
  AND (tblAssetCustom.Model <> 'Virtual Machine')

in my WHERE clause. (I could get away with just checking the model, but I like to cover all my bases.)