cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Use Orion Alert Manager to detect unstaible Nodes which goes up and down?

Hi,

We are normally only reporting Nodes which has been down for 30 minutes. But we would also like to recieve an email when a Node has gone "up and down" for a certain time.

We do not want to recieve an email each and every time this unstaible Nodes turn down and up, but lets say an email would be generated when a node has turned into down state for x times in x hours.

Is this possible and which is the best way of doing this?

Thanks in advance!

Andreas Fenner
Stockholm, Sweden.

0 Kudos
3 Replies
Level 13

You can make use of the Advance Alert trigger condition tab,especially you can look for the "Custom SQL" option in the Type of property to monitor.This will allow to write any custom sql using the values from the Orion database.I suppose this should work for you.

0 Kudos

  Can you provide an example of how we would use "Custom SQL" for this, especially for those of us who are not DBA's?

0 Kudos

Similar to my other post: ">

The following would trigger for more than 12 node downs in 12 hours.

Type of Property to Monitor: Custom SQL Alert
Set up your Trigger Query: Node

WHERE
Nodes.NodeID IN (
  SELECT NetObjectID
  FROM Events
  WHERE  NetObjectType = 'N' AND EventType = 1 AND EventTime >= DATEADD(HOUR,-12,GETDATE())
  GROUP BY NetObjectID
  HAVING COUNT(1) > 12
)

EventType = 1 is the node down code (see the EventTypes table for a list)
DATEADD(HOUR,-12,GETDATE()) calculates 12 hours ago
NetObjectType = 'N' pulls only Node events
HAVING COUNT(1) > 12 for those that match more than 12 times (adjust accordingly)

0 Kudos