Alert Custom Setting

Hi,

I want to create a custom reset condition that will enable the alert to reset if both conditions are true:

1. Threshold is below the 90% utilization
2. Alert is “Acknowledged”

Is there a way to set a condition for number 2?

Find more posts tagged with

Alert

solarwinds

npm

reset condition

Alerts

Accepted answers

mesverrum

Sounds like you weren't on the correct page to set a custom reset condition if you had those variables available to you. It would look like this

SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes

join orion.alertactiveobjects ao on ao.relatednodeuri = nodes.uri
where cpuload < 90
and ao.alertactive.acknowledged = 1

All comments

mesverrum

not from the GUI options but it could be done with sql/swql

mykopascua

I used ${N=SWQL;M=SELECT ${N=Alerting;M=Acknowledged} } but I do not know what value would be equivalent to an acknowledged alert. I also tried to enter Status Values but it does not seem to work.

mesverrum

Sounds like you weren't on the correct page to set a custom reset condition if you had those variables available to you. It would look like this

SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes

join orion.alertactiveobjects ao on ao.relatednodeuri = nodes.uri
where cpuload < 90
and ao.alertactive.acknowledged = 1

mykopascua

Hi,

Thanks for the help mate. I have managed to apply the query but it does not seem to take any effect. I'm starting to think maybe I need to adjust the trigger condition as well since the only trigger condition I have in my alert is if node cpu load >= 90