Hi,
I want to make an alert when some nodes have status Down for example if I have 100 nodes in NPM but 50 nodes are Down (no metter what they are) in this moment I want an email to be send. Can you help?
Thank.
The tricky thing with this is that SolarWinds requires an entity to alert against, no matter what the trigger criteria. You could create a "fake" node with the polling method of 'External' and then write yourself a custom SQL/SWQL alert that causes an alert to trigger on this node when your your "50% or more" criteria is met.
The name has to resolve, so naming it "ThingsAreGoingPoorly" won't work, at least upfront. You can use one of the localhost addresses (127.0.0.0/8) and then rename it on the final step:
And then...
And finally a custom SWQL alert definition targeting that node and only triggering when the total down nodes / the total nodes produces a number greater than 0.5 (50%).
All that being said, the testing I did didn't seem to work quite right, but this might get you started. Here it is again pasted in regular text:
WHERE Nodes.Caption = 'ThingsAreGoingPoorly'AND (SELECT COUNT(1) AS Qty FROM Orion.Nodes WHERE Status = 2) / (SELECT COUNT(1) AS Qty FROM Orion.Nodes) > 0.5
Hi martin.riubi,
Another simple way is to write an alert rule. Go to Settings -> Manage Alerts -> Add New Alert.
Fill the details in the Properties tab and then go to Trigger Condition tab. All you need here is to write a condition which meets the Node status as shown below.
2 means Down status. You may want to add extra conditions, if you want to receive alerts only for a particular type of devices or specific device(s), etc. We have the alerts setup and receiving alerts.
Hope it helps .
That would just create individual alerts on the down nodes, right? It doesn't cover the requirement of ">= 50% of the nodes are down"?
Yes, true. It generates alert for each node, which is down. For that purpose, a count of the node down should be sent an email to his email-id.
Of course, you rule works, but I don't think that condition > 0.5 is required. If 40 nodes are down, then? He had just mentioned an example that he wanted to know these many Nodes were down.
So if he has 100 nodes and 50 of them go down he'll receive 50 emails. So he'd know that 50 of his nodes were down. I picked the 0.5 threshold because that's half of the nodes (50 out of 100). It would send a single email instead of 50 of them and he could get the total number of nodes down with a SWQL variable inserted into the message like this:
Total nodes down is currently: ${N=SWQL;M=SELECT COUNT(1) AS Qty FROM Orion.Nodes WHERE Status = 2}.
