This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Triggers for alerts on traps

davelintelco over 5 years ago

I have read some posts on here that are related but, not specific to my case.

It seems that trap manager is not available to me but, I can create a custom SQL trigger from the trap list in the NPM web interface.

Error Condition looks like this (trapPerceivedSeverity = major(5) )

Cleared condition (trapPerceivedSeverity = cleared(1) )

I created a trigger that sort of works but it does not address whether it's the alert trap or the clear trap.

It just tells me it either errored of cleared in the last 30 minutes

I think I need to do a second join to trapvarbinds to get the "trappercievedseverity" but I can't figure out the syntax.

Top Replies

0 mesverrum over 5 years ago

I don't have the db open in front of me but its just something to the effect of
join trapvarbinds on trapvarbinds.trapid = traps.id
or it might be traps.trapid, the db naming conventions are a little bit inconsistent sometimes.
Cancel
Vote Up 0 Vote Down

Cancel
0 davelintelco over 5 years ago in reply to mesverrum

I'll give that a try. Thanks.
Cancel
Vote Up 0 Vote Down

Cancel
0 lynchnigel over 5 years ago

indeed you do heres the full trap alert we are using...
Cancel
Vote Up +3 Vote Down

Cancel
0 davelintelco over 5 years ago in reply to lynchnigel

That is exactly what I was looking for!
Thanks
dc
Cancel
Vote Up 0 Vote Down

Cancel
0 lynchnigel over 5 years ago in reply to davelintelco

You're welcome - can you mark the answer as correct if it helps
Cancel
Vote Up 0 Vote Down

Cancel
0 pratikmehta003 over 5 years ago in reply to lynchnigel

How to get the trap description into trigger action? I mean what variables will help in understanding it? Coz i have SOlarwinds integrated to SNOW so i need to pass proper descrption to decode it further....
Cancel
Vote Up 0 Vote Down

Cancel
0 lynchnigel over 5 years ago in reply to pratikmehta003

Its hard to know without any context and you will need to find the mibs the device is firing on as that above is the alert action. The alert trigger IE for the above we use
${N=SwisEntity;M=OrionServer.HostName}Traps.HostName
trapvarbinds.OidName, trapvarbinds.OidValue
${N=Alerting;M=AlertMessage
Cancel
Vote Up 0 Vote Down

Cancel
0 pratikmehta003 over 5 years ago in reply to lynchnigel

is it working in your scenario?
Cancel
Vote Up 0 Vote Down

Cancel
0 lynchnigel over 5 years ago in reply to pratikmehta003

Is what working?
This works as an alert for us yes.
Cancel
Vote Up +1 Vote Down

Cancel
0 bobmarley over 2 years ago in reply to lynchnigel

Genius!!!!!! Thank you. Worked perfect for us on 2020.2.6 with the old school trap receiver. (we never upgraded)

Typed it up below for a simple cut/paste (top 3 lines are already there in the Node SQL Alert)

SELECT Nodes.Caption, Nodes.NodeID FROM Nodes

INNER JOIN Traps

ON Nodes.NodeID = Traps.NodeID

INNER JOIN TrapVarbinds
ON Traps.trapid = Trapvarbinds.trapid

AND (Trapvarbinds.OidValue LIKE '%battery%')

AND Traps.DateTime>Dateadd(MINUTE, -2, SYSDATETIME())
Cancel
Vote Up +1 Vote Down

Cancel