cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Problems generating alert from custom poller

I'm hoping there may be an easy fix for this as I'm quite new to this and could well be missing something simple.  I'm trying to generate an alert from a custom poller.  The poller appears to work correctly and returns a value of 0 or 1 from the device I am monitoring (it is actually an alarm condition).  It seems to function whether the format is 'none', 'text' or 'enumeration' for the purposes of displaying a graph for the node.

The attachment shows how I currently have the alert trigger configured with just two conditions:

poller name equal to IBUC10MHzalarm

numeric status equal to 1

The alert action I have is just to write to a text/log file.

I have also tried 'status' in place of numeric status and tried various changes to the format in the poller e.g. setting to text and using status instead of numeric status as I thought the issue may be with this, but no combination seems to yield a result.  I see no alerts generated.

I am assuming the alert should be generated from any node the poller currently monitors.

I've had a look at some other posts and people appear to have results using similar alert conditions and pollers.  Any suggestions are appreciated.

0 Kudos
10 Replies
Level 7

Finally found the issue.  It was alert suppression, although not from within the suppression tab in Advanced Alert config.  From System Manager select Alerts then Configure Basic Alerts there is a check-box to temporarily disable all alerts.  (see attached).  This doesn't appear in the Advanced Alerts section.  Thanks to all that responded.

Monty

0 Kudos

Thanks for sharing the final solution although I am not getting why basic alerts settings would block advanced alerts.

This doesn't appear in the Advanced Alerts section


It does since NPM 9.5. it is filed under "Improved advanced alerts interface." in the release notes.

0 Kudos
Level 13

monty,

I haven't done much alerting from custom pollers, but I was wondering if you happen to have anything configured under the alert suppression tab. This probably isn't your issue, but I have run into problems in the past with alerts not firing when I tried to include suppression.

0 Kudos

kweise,

Thanks for the suggestion, but there is nothing configured under alert suppression, everything at default.

cheers,

Monty

0 Kudos

Hi Monty,

The next step would be to check in which field the UnDP has stored the value returned in the CustomPollerStatus table.

You can use the SQL Query pasted below. Put the name of your UnDP in the WHERE condition.

Once you figured out which field hosts the value, it should become obvious which field to choose in the alert if the right one was not selected to build the conditions.

SELECT CPA.AssignmentName, CPS.Rate, CPS.Total, CPS.RawStatus, CPS.Status, CPS.RowID
FROM CustomPollerStatus AS CPS
INNER JOIN CustomPollerAssignment AS CPA ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID
INNER JOIN CustomPollers AS CP ON CPA.CustomPollerID = CP.CustomPollerID
WHERE CP.UniqueName = 'NameOfYourUnDP'

You can use Database Manager, Report Writer or SQL Server Management Studio to execute this query.

If you have any questions, do not hesitate.

HTH,

Yann

0 Kudos

Yann,

Thanks for your assistance. I have tried your suggestion and, with the poller format at none (rather than enumeration or text etc), it returns a value in both RawStatus and Status. I will attach a screen shot. The value in both is the same i.e. both 0 when OK and both 1 when in alarm status. It toggles successfully when I put the equipment into the alarm state. Am I correct in thinking this suggests the parameters in the Alert are set correctly?

I tried experimenting with changing the poller format which does alter what appears in the fields with the SQL database query. I then tried creating a new alert accordingly but this didn't yield any result.

Best Regards,

Monty
0 Kudos

It toggles successfully when I put the equipment into the alarm state. Am I correct in thinking this suggests the parameters in the Alert are set correctly?

I would say yes for the trigger condition. Is the alert being reset when the value goes back to 0?

If yes, then it pretty means that you can lay back on your seat and let NPM and the alert work for you :).

0 Kudos

Yann,

Thanks for the reply.  I'm slightly confused by part of it, and I'm maybe missing something, so I should maybe clarify what I said previously.  When I say toggles correctly, the value returned from the equipment changes as expected and consequently the value returned from the SQL query etc toggles.  What doesn't happen is any of my alert actions and I don't get it appearing as an active alert or in the log (and no alert clear/reset message either).  The reset condition is default, I think this is 'when condition no longer met' or something similar.

thanks,

Monty

0 Kudos

When I say toggles correctly, the value returned from the equipment changes as expected and consequently the value returned from the SQL query etc toggles.

This means the UnDP is working fine. Ok.

What doesn't happen is any of my alert actions and I don't get it appearing as an active alert or in the log (and no alert clear/reset message either).

This means we have a problem with the Trigger Condition of your Alert.

Could you post a screenshot of your Trigger Conditon tab? And/Or the sql query stored in the TriggerQuery field in the AlertDefinitions table ( SELECT AlertName ,TriggerQuery FROM AlertDefinitions ) ?

Thanks,

0 Kudos

Yann,

Thanks for yor response.  The trigger query is as follows:

{F1ESELECT CustomPollerAssignment.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignment.AssignmentName AS Name
FROM (CustomPollerStatus INNER JOIN CustomPollerAssignment ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID))  LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID)
WHERE 
(
  (CustomPollers.UniqueName = 'IBUC10MHzalarm') AND
  (CustomPollerStatus.Status = '1')
)

There should also be a screen shot at the start of this post.  I've added a shot of the trigger actions also.

I did notice something that may or may not be relevant.  When opening the DB manager again I could not connect to the database.  I had to delete and add the same one again with the same name and login details and it then responds.  I'm using SQL express.  The reason I though it may not be relevant is because in the previous tests I had the DB manager open was responding as expected to the SQL queries.  Other than this Orion is running fine and monitoring the network of routers.

thanks again,

Monty

0 Kudos