Writing an advanced alert to look at two nodes assigned to the same application monitor, and I need the advanced alert to trigger only when the monitor goes down on both

Question

Writing an advanced alert to look at two nodes assigned to the same application monitor, and I need the advanced alert to trigger only when the monitor goes down on both   --

SELECT DISTINCT APM_AlertsAndReportsData.ComponentID AS NetObjectID, APM_AlertsAndReportsData.ComponentName AS Name  FROM Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)

WHERE   (  (APM_AlertsAndReportsData.ApplicationName = 'Oracle Database monitor')

AND   (Nodes.IP_Address = 'xxx.xxx.xxx.xxx')  AND (Nodes.IP_Address = 'xxx.xxx.xxx.xxx')

AND  (APM_AlertsAndReportsData.ComponentName = 'Oracle User Experience Monitor')  )

This syntax only works with or , but not 'AND'  How can I get the code to look at both nodes / monitor and trigger on both when the monitor detects the monitor down on both during the same time period.

It is a cluster.

zackm · Answer

You could also make this a custom SQL alert to get past the and/or limitations:

WHERE  (APM_AlertsAndReportsData.ApplicationName = 'Oracle Database monitor')AND  (APM_AlertsAndReportsData.ComponentName = 'Oracle User Experience Monitor')AND  ((Nodes.IP_Address = 'xxx.xxx.xxx.xxx' AND ComponentStatus = Down)AND(Nodes.IP_Address = 'xxx.xxx.xxx.xxx' AND ComponentStatus = Down))

Replacing "ComponentStatus" with the proper field of course. (I don't have a lab in front of me right now)

To be fair though, I would probably make a group like our friend the mashed avocado

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

* LinkedIN: Loop1 Systems
* Facebook: Loop1 Systems
* Twitter: @Loop1Systems

HolyGuacamole · Answer

Worst case - group will get the worst status of a group member. So, in your use case, the group will get a down when either of the application monitors are down

Best case - group will get the best status of a group member. In your use case, when at least one of the members is up, the group is up. When both are down is when a group will be in down status.

jcorcoran · Answer

Thanks HolyGuacamole !!

So just to clarify -   The group with worst status will trigger on if both monitors are down and not on one downed monitor ?