UnDP Tables and Advanced Alerts?

theit8514

I'm using the universal poller to query the status of a QLogic SAN switch, which uses a MIB not provided by the NPM (.1.3.6.1.3.94 / FCMGMT-MIB)

I created two seperate pollers (with GET TABLE) as specified in another post:
.1.3.6.1.3.94.1.10.1.17 as SANPortName (aka. "Port1")
.1.3.6.1.3.94.1.10.1.23 as SANPortStatus2 (aka 4 for active, 8 for link down)

I set up the enumerated values for SANPortStatus2 and added column .2 as the label identifier for both pollers. The node details page now shows the port names and text status, but now I would like to add an alert for rows in that poller that are marked "link down"

My Alert is set up to monitor "Custom Node Poller", triggers are:
Poller Name is equal to SANPortStatus2
Status is equal to Link Down

There are currently two ports that are link down, but the alert only triggers once. What bothers me is that when I try to set up a custom SQL query to pull the port name, it didn't work. I found out why later when I just put the variables in instead of the SQL query I was attempting. The variables is showing ALL rows when it triggers the alert. Here's an example with the alert text = ${CustomPollerStatus.RowID} ${CustomPollerStatus.Status}

 2/23/2010  10:02  16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.1, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.10, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.11, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.12, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.13, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.14, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.15, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.16, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.2, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.3, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.4, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.5, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.6, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.7, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.8, 16.0.0.192.221.13.115.15.0.0.0.0.0.0.0.0.9 Active, Active, Active, Active, Active, Active, Active, Link Down, Active, Link Down, Active, Active, Active, Active, Active, Active

It shows all the rows in the table not just the row(s) that are "link down." Is there any way to alert on a single row in a poller, not the entire poller?

morgolis

I wouldn't expect it to alert more than one.  You'll need to include the status for all the devices that have been stored in the database that was obtained by the UnDP.  When you created the alert, it checks all the values that were obtained starting on the first row and it will alert when it hits it's first match.

I would suggest that you include the status messages for all the rows in your alert message to make sure that any other ports that may be down are included.

If you can find individual OIDs for each port status, you could store them individually and then alert on each one.

Hope this helps.