Hi All,
I'm new to Solarwinds NPM, i was trying to create a trigger if a nodes is consider down after 3 polling time only start trigger emails.
My setting of alert is as below but i not sure is this the correct way.
Regard,
Kwan
What I have found when creating alerts is to go grab the sql query which is generated when you design your alert and run that on the database directly and adjust from there. Afterall, all alerting is doing is querying the db. So in this case, you want an alert generated in the form of an email when a device is failed for 3 poll cycles? The Poll Interval variable however is defined as the node polling interval in seconds, which default i think is 120 seconds so that should technically apply but not exactly what you are looking for. Why not just your trigger as node status is not equal to up and then do not trigger the action until condition exists for X number of seconds / minutes?
It's pretty easy as long as you know your polling interval. If you leave it at the default (120 seconds) then 3 intervals is 6 seconds. So your alert trigger is really just:
Node Status is equal to down
and then at the bottom of that same tab, set the trigger delay to 6 minutes (or 7 if you want to be on the safe side).
As a side note, you don't need that "trigger alert when ALL of the following apply" block.
Jay,
I have a few questions. I am also new to SolarWinds.
Using Advanced Alert Manager, I created the above alert.
How do I "grab" the SQL Query?
How do I run the SQL Query against the database?
When I create the condition, Response Time is greater than or equal to 2563, is 2563 seconds or 2563 milliseconds?
Thank you,
tjreeddoc - Click on general tab and grab the name of the alert. Then head over to your sql server, and open up the dbo.AlertDefinitions table in the solarwinds db. I typically do a right click on the table, and "Select Top 1000 Rows" since I have less than 1000 created alerts. Once that query is run, I usually add a where clause to help find the alert in question easier; WHERE AlertName LIKE '%example%'
Once I have the alert selected in the results pane, you can scroll over to the right, and one of the columns will be labeled "TriggerQuery" You can right click that query and copy it and paste it into a new query window. This will then show you what elements would effectively qualify under the alert you have created. If you have any other questions, feel free to ask.
As far as your response time, I believe its milliseconds.
