Here's the scenario:
LabTech has an Offline Locations monitor. This monitor is meant to alert (if you enable it) if no systems at a location are online. This is very useful for us in many scenarios, but not when a client has no permanently-on systems.
Unfortunately, it's only at the top level, so rather than change from a group, it looks like I'll have to change this with a custom monitor (disabling the in-place monitor). Here's the Monitor condition:
(Select Count(*) from Computers Where Computers.locationid=locations.locationid)>0 and (Select Count(*) from Computers Where Computers.locationid=locations.locationid and Computers.LastContact>Date_Add(Now(),Interval -10 minute))=0 AND locations.LocationID NOT IN ('1','2')and (SELECT `Exclude Offline Check` <> 1 FROM v_extradatalocations WHERE v_extradatalocations.locationid=locations.locationid)
I want to add an "Except when Location is part of <MyExampleGroup>" so that I can use an EDF+autojoin search to add locations to <MyExampleGroup> such that those groups will not flag an alert, but everything else will. As I'm not an SQL wizard, what would I change?
Thanks for any help you can provide.