Multiple Custom Poller Values in Advanced Alerts...**Resolved**

k1gaudineer

Good evening NPM community...  I have run into a wall with 'Custom Pollers'...  My end goal is to get the value of two or more custom pollers in a email alert that is also triggered from a custom poller.  I am finding that this is not as easy as I thought.

The customer request is

1.  An alert that will send an email when a UPS switches from utility power to battery backup

2.  In the body of the email alert they would like to see

        a.  The output source

        b.  The battery charge remaining

        c.  The minutes remaining

        d.  The battery condition

a, b, c & d need custom pollers.  Those have been setup and are collecting the data.  The alert for detecting when utility power is lost and switches to battery backup is setup and working.  That is the custom poller alert for item (a).  But the value of (a) is all that I can get in the alert.  the remaining 3 custom poller values I can't figure out how to add them to the body of the email.  Its almost like you can only have one custom poller per alert.  I have tried adding custom properties and getting the custom poller values to populate the custom properties but that didn't work.

Do I need to use SWQL or possibly a SQL to get he values from those pollers?  I am not an SQL guru but if that is necessary would it be possible to use the old report writer on the SolarWinds server to create an SQL query that could be copied and pasted into the alert definition to get the values?

k1gaudineer

I have the solution for the multiple custom pollers in an advanced alert...  I spent a few days (many hours) reading through post here...  reading through post on the MRTG message boards, reading through the MIB text file from TrippLite, the RFC, and experimenting with report writer to get a working SQL statement.  Remember the customer request was to receive an email.  Not a link to a web page or a report attachment.  They want a formatted email message.

These alerts do work  and I have deployed them in the customers environment approx a little more than 400 TrippLite UPS'.  These are advance alerts created in NPM V12 and the TrippLite UPS' are SU1500RTXL2Ua and the firmware is a mix of 12.14.0045,

12.04.0055, 12.04.0053 and 12.04.0049.

The first thing I needed to realize was that I couldn't use a variable in the advanced alert.  I needed to use an SQL statement (SWQL possibly but could get that to work).  I used the following 'Private' mibs for the pollers

1.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.44  (Get)  Name= trippUPSOutputSource_A

2.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.45  (Get)  Name= trippUPSOutputSource_B

Some UPS' used the .44 and some used the .45 for output source so I created an OR condition for the alert trigger.  During normal operation the 'trippUPSOutputSource' will be equal to 'Utility'  When utility power is lost it will change to 'Battery'...

The other mibs used are...

3.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.25  (Get)  Name= trippUPSBatteryChargeRemaining

4.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.31  (Get)  Name= trippUPSBatteryCondition

5.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.32  (Get)  Name= trippUPSBatteryCharge

6.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.33  (Get)  Name= trippUPSBatteryStatus

7.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.30  (Get)  Name= trippUPSBatteryTempF

8.  1.3.6.1.4.1.850.10.2.3.1.1.7.1.28  (Get)  Name= trippUPSSecondsOnBattery

The SQL statement used in the advanced alert is below.  I just pasted in the SQL following the 'Select' statement when creating the alert.

CustomPollerStatus.Status FROM CustomPollers RIGHT OUTER JOIN CustomPollerStatus LEFT OUTER JOIN CustomPollerAssignment ON CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID ON CustomPollers.CustomPollerID = CustomPollerAssignment.CustomPollerID WHERE (CustomPollers.UniqueName = 'My_Custom_Poller_Name_Here') AND (CustomPollerAssignment.NodeID = ${NodeID})}

Once I had all of the pieces in place this is what the alerts looks like when the customer receivers the email...  The first screen shot is when the UPS first switches from Utility power to Battery Backup...

This  next screen shot is the alert sent out when utility power is not restored and the batteries in the UPS are being depleted.

This screen shot is the email received when the utility power is restored and the critical alert is cleared....

***Note in the above screen shot....  The 'Output Source' is standby.  This means that utility power has been restored, the battery is charging but the outlets for devices connected have not been turned on.  ***

And finally the alert received when the UPS has been back on utility power for a while and the battery has charged back above an acceptable level

The customer is happy and I'm happy that the customer is happy..  Hopefully this info and screen shots will help others over the hump when it comes to using multiple custom pollers in an advanced alert.