Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Orion Custom Poller Alerting - SQL woes

Hi guys,

So I created an alert based on a custom poller, with the conditions:

Poller Name is equal to status

status is equal to disconnected.

The poller basically checks if an access point is disconnected, and if it is, send out an email. The content of the trigger action active the following action, showing the location of the AP:

Location: ${SQL:Select status From CustomPollerAssignment as Assignment, CustomPollerStatus as value where Assignment.CustomPollerAssignmentID = value.CustomPollerAssignmentID and Assignment.NodeID = '${NodeID}' and Assignment.AssignmentName like 'desc%';}

Now till last week everything was working fine and the correct location was being reported, now it seems like something has changed and the first polled connected AP location is returned, which is not the same as the disconnected AP location.

As per my understanding Orion checks for a particular alert condition, and if true, any queries against that CustomPollerAssignmentID is for that particular condition which is true (disconnected AP). I have tried changing the alert conditions but it seems to be returning me the wrong, connected AP every time!

I have tested this on other sites and they all exhibit the same behaviour, restarted Orion services and still no luck. Would appreciate any help regarding this problem, as I really don't know what I'm doing wrong here.

Find more posts tagged with

Accepted answers

All comments

smargh

1) Could you post a screenshot of the Orion pages which shows the table for this access point connection status? I find they're useful to visualise what information I need to alert on.

2) Do you have one alert per node, or one alert covering lots of nodes?

demon777

Resolved by using four inner joins on two tables within Orion Works like a charm - let me know if anyone needs help with this.

drewdavis1

Could you please post the SQL that you used to resolve this? I'm having a similar issue for an alert that triggers based upon a UDP of a SNMP table value. The trigger works fine but including the particular value from the table, and not just the first returned value, in the email is proving to be difficult.

demon777

Here is my script:

Select StatusTBIP.status From CustomPollerAssignment as AssignmentTBIP Inner join CustomPollerStatus as StatusTBIP ON AssignmentTBIP.CustomPollerAssignmentID = StatusTBIP.CustomPollerAssignmentID Inner join CustomPollerStatus as StatusTBConnectionStatus ON StatusTBConnectionStatus.RowID = StatusTBIP.RowID Inner join CustomPollerAssignment as AssignmentTBConnectionStatus ON AssignmentTBConnectionStatus.CustomPollerAssignmentID = StatusTBConnectionStatus.CustomPollerAssignmentID where AssignmentTBIP.AssignmentName like 'Description%' and AssignmentTBConnectionStatus.AssignmentName like 'Status%' AND AssignmentTBIP.NodeID= '${NodeID}' and StatusTBConnectionStatus.Status='disconnected';

I have ofcourse custom pollers by the name of Description etc - you would just need to change the poller name to and status to get appropriate values.