This is a custom SQL query that validates just fine. But when I finish the alert, it will never fire off. SolarWinds said I should try you guys. But any idea would be outstanding.
This is a custom SQL query that validates just fine. But when I finish the alert, it will never fire off. SolarWinds said I should try you guys. But any idea would be outstanding.
can you run that query directly against your database and get results?
Loop1 Systems: SolarWinds Training and Professional Services
In your initial query, you have the rate within single quotations. You might need to remove these, as it tends to look at items within single quotations as strings rather than values. e.g. It might think 9 is a string like a word, instead of a number. This is good for the CustomPollerAssignmentID, but not the rate.
Once you do this, just make sure you write out your actions to include Rate or Value as numeric.
Hope this helps at least a little. =)
1. Looks like you are setting this up through the web console, which tells me you are running 11.5, right? (I'm not running 11.5, so this could complicate any assistance I might be able to provide...however I know the Loop1 guys should be able to help if you continue to have issues).
2. When you build an alert in 11.5 it should tell you how many devices fit the requirement to alert on it before you complete it....what does it tell you? If it's 0, then the problem is the logic of the alert trigger.
3. In the alert, do you have a "condition must exist for x time" stipulation? You might just not have an alert yet.
I'll let you know if I think of something else that might be causing this, but have you thought of just setting this up as a standard alert instead of Custom SQL? The same attributes you're trying to filter on should be readily available.
As long as you know the name of your poller, you can do this:
"Trigger Alert when All of the following apply:
Poller Name contains (or is equal to works here) <Name>
Rate is equal to or greater than 9"
Easier to configure and for the next engineer to understand. Just an idea, don't know if you're planning on making this more complex in the future. =)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.