To cut down on e-mail clutter from our alerts, I'm setting up a morning report to be e-mailed to my team with the current servers in Warning or Critical state. To avoid this triggering for other network equipment, I want to put in a limit here using SQL. Our servers are mostly Windows, but we have a few Cisco USC. Would this SQL code in the report to filter these:
Vendor = 'Windows' OR MachineType = 'Cisco USC'