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?
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
Yep, that what is so confusing. The query refuses to fire off an alert.
can you post a screenshot of your SQL results from this query (replacing ID with the GUID from your original query:
SELECT * FROM CustomPollerStatusTable WHERE CustomPollerAssignmentID = 'ID'
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.
I took out the ' '
It still Validated, but nothing yet on the alerts.
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.
Would the CompressedRowID field coming back as NULL make the query not work?
Yes, 11.5.
I guess I'll just wait to see if anyone helps. I have been back and forth through everything. SolarWinds has too.
What OID are you using to get these results?
1.3.6.1.4.1.9.9.86.1.2.1.1.8
I unfortunately do not have any VoIP equipment that I can test this on. Have you tried creating a new UnDP? I am really not sure why your CompressedRowID entries are all NULL. In my lab, all of them reflect the integers in the RowID column.
This is a new column (CompressedRowID) in the database. I am thinking at the very least you should open a ticket with SolarWinds to get escalated as a potential bug.
The only other idea I would have would be to create a custom SQL alert based on the Node, then join that table across the CustomPollerAssignment table and then into the CustomPollerStatusTable view. However, without having solid data to test with, I cannot promise there wouldn't be some problems with the alert still. (Also, you would just get an alert on the node, not the interface)
Basically, it would be something like:
SELECT NodeID, Caption from Nodes
JOIN CustomPollerAssignment on CustomPollerAssignment.NodeID = Nodes.NodeID
JOIN CustomPollerStatusTable on CustomPollerStatusTable.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID
WHERE CustomPollerAssignment.CustomPollerAssignmentID = 'ID GOES HERE'
AND CustomPollerStatusTable.Rate > '9'
I think your problem is going to be that you have one object (NodeID) that has X # of rows in the table. This will more than likely cause some issues with the trigger and reset. But it's worth investigating while waiting on SolarWinds to process the ticket.
Good luck! If you have questions, just ask.
SolarWinds, when you try to create a custom SQL trigger, automatically populates the box with it's Select statement. How would I go about joining tables and such?
