I would like to monitor event logs for only a subset of my servers running SQL Server. I can set up the filter for Eventtype = 1, Source = MSSQLSERVER, but I am not sure if the rules are 'ands' or 'ors'. That is to say, if I put in rules for:
Computer = mycomputername
Computer = yourcomputername
Compuer = fred
will I get only reports from those 3 servers or none at all since the rule would be using 'ands' not 'ors' ( I am assuming they are 'ands').
If the later is the case, how does one report on just a subset of servers using the filters?
Thanks very much.