We are using the default unauthorized software report to scan our network for computers with unauthorized software. We have a small number of computers that are allowed to run a couple programs that are otherwise not allowed. I want to change the query to not show those machines every time. I have tried putting all of the assets to be whitelisted in a group and then using the AssetGroup filter and it will not exclude items in the group with the below example.
Where tblAssetGroups.AssetGroup != 'Test' And tblSoftwareUni.Approved =
2 And tblAssetCustom.State = 1
The only way I have gotten it to work is to do the following
Where tblAssets.AssetName Not In ('hostname', 'hostname1',
'ect')
The above method works to get them out of the list but it is messy and I would like to be able to add whitelisted computers to a group as that is simpler.
Also is there a way to have it only exclude the computers from the group only for the specific software. For example Computer A is running a blacklisted piece of software that we approve so I do not want it in the report, but if it runs a different piece of blacklisted software that is not approved I still want to know.