Why are my alerts not filtering properly????

Question

I have some alerts that are triggering but I believe they should not be. This is the query that is listed int the web console. I can see that node status piece is wrong. SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name FROM Nodes WHERE ( (Nodes.Status = '2') AND ( (Nodes.DisableAlerts <> 1) OR (Nodes.Status <> '9')) ) How should I exclude any node that is unmanaged and/or has DisableAlerts = true?

zzz · Accepted Answer

The OR should be an AND.

Currently only if the Node is BOTH disabled and Status = 9 (which shouldn't be possible anyway as its status = 2) will be filtered.

Note that this alert is possible without using Custom SQL (status = Down, trigger when none -> status = unmanaged, disable=1). Unless you are really familiar with SQL, I would recommend to keep using the default trigger mapping rather than Custom SQL. As long as you are familar with grammar, you can trace the logic from that more easily.