You have to use table name together with column, e.g. Interfaces.Status=2.
remove Cisco ASA's - identify column and the value in Nodes table in database you will use to filter Cisco ASA's
e.g. Nodes.MachineType not like 'Cisco ASA*'
You can use the following SQL to effectively remove the discards and only get the errors.
Top XX errors for Today filter
(InErrorsToday > 250) OR (OutErrorsToday > 250)
Top XX errors for Hour filter
(InErrorsThisHour > 250) OR (OutErrorsThisHour > 250)
(This is custom properties for me, like this catagory, building or device type, some custom property setups don't alert or don't alert to us so I leave those out of this alert.... ') and (InErrorsThisHour > 0 or OutErrorsThisHour > 0)
This next part is to make sure there are Errors. No minimum requirement, but it does get rid of the 0 error, 10K discards you see from your firewalls doing their job.
If you don't have any other leading conditions and you want all nodes just use the in errors and such. As John King mentioned you can use the In/Out Error's
Today setup instead and for that you may want to set a threshold. I like this hour because it keeps things current. Maybe one for the desktop, one for the NOC.