With some SQL commands to create an alert on flapping Nodes. Important for this is also how often you poll the Nodes Status !!!
Trigger Condition:
Set up on Node
In the Alert select custom SQL
When you select Node it preselects this statement
SELECT Nodes.Caption, Nodes.NodeID FROM Nodes
In the SQL condition please paste
JOIN Events ON Nodes.NodeID = Events.NetObjectID
where eventtime >dateadd(hour,-1,getdate()) AND EventType = '1'
group by EventType, NodeID, Caption, Message
having count(*)>=3
Reset condition:
where LastSystemUpTimePollUtc < dateadd(hour,-1,getdate()) AND Status = '1'
As Example for a Email (html):
${N=Alerting;M=AlertName} was triggered.${N=SwisEntity;M=Caption} ${N=SwisEntity;M=DetailsUrl}
So when in one Hour a line is flapping three times down (=down,up,down,up,down) the alert will trigger.
When the Node is ok since 1hour and up there will come the reset.
