Convert Trap to Alert?

 Denny - your developers lied to you....  I did it...

-Adam

To Manually Trigger An Alert:

Insert INTO AlertStatus (AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, TriggerCount)

                                                VALUES                                ('{846CC1D9-7947-4AD6-A7FA-43D905836FED}',2617,'Node',2,0,'SNMPTRAP',1)

Or

Insert INTO STOREWAN..AlertStatus (AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, TriggerCount) VALUES ('{846CC1D9-7947-4AD6-A7FA-43D905836FED}',2617,'Node',2,0,'SNMPTRAP',1)

                                * - 2617 is the ID of my filler node SNMPTRAP

                                ** - you can only add one alert like this at a time, because you can only have one active instance of an alert on a given node

Custom Reset Query:

You want to clear your manual alerts when they are acknowledged because if you don't "AlertStatus" tables will accumulate or you won't get alerts.   IMPORTANT – this seem to get wiped out if you edit the alert using the GUI.

How to:  Find the your custom alert in the table "AlertDefinitions", by "AlertName", and enter the following in the "ResetQuery" field:

SELECT AlertStatus.ActiveObject AS NetObjectID  FROM AlertStatus  WHERE    (    (AlertStatus.Acknowledged = '1')  )   

Linking to Traps:

From the trap manager, you can go to "View->Alerts/Filter Rules", and associate traps with Alerts(*) and Actions

(* - not Solarwinds Advanced Alerts unfortunately, or I wouldn’t have do to any of this – they’re >email< alerts)

We’re not doing an email alert though – do an “Action - Execute an external program”, and specify a batch containing this command:

bcp "Insert INTO STOREWAN..AlertStatus (AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, TriggerCount)VALUES ('{846CC1D9-7947-4AD6-A7FA-43D905836FED}',2617,'Node',2,0,'SNMPTRAP',1)" queryout temp.txt -T -c           

Test The Process:

Trapgen works well enough…

trapgen -d 192.168.1.111 -v 1.3.6.1.4.1.1824.1.0.0.1 STRING "This is a test..."