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!
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.
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)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.