Alert Based on SNMP Trap

Kbr0125

Im trying to create an alert based on a trap that is being sent to solarwinds server, This is the current custom SQL alert that i have set, how do i have it check against stuff inside the trap details and not just the trap type. These lines in the trap details are unique to the AC Main power getting unplugged / lost.

dcPwrSysAlarmTriggerValue.9 = 10024
dcPwrSysRectAlrmIndex.9 = 9
dcPwrSysRectAlrmStringValue.9 = Rect. AC Mains Fail

WHERE  nodeid IN (SELECT nodeid

                  FROM   traps

                  WHERE  traps.traptype = 'AlphaPowerSystem-MIB:dcPwrSysAlarmActiveTrap'

)   

This is the SNMP Trap that gets sent when the AC is unplugged for the UPS/Rectifier:

AlphaPowerSystem-MIB:dcPwrSysAlarmActiveTrap 

dcPwrSysAlarmTriggerValue.9 = 10024 
dcPwrSysTimeStamp.9 = 2020/10/20 07:17:09 
dcPwrSysSiteName.9 = rect01.roc​h 
dcPwrSysRectAlrmSeverity.9 = 0 
dcPwrSysRectAlrmIndex.9 = 9 
dcPwrSysRectAlrmStringValue.9 = Rect. AC Mains Fail 
snmpTrapOID = AlphaPower​System-MIB:d​cPwrSysAla​rmActiveTr​ap 
sysUpTime = 1 hour 0 minutes 11.36 seconds 

This is the SNMP trap that gets sent when AC power is returned to the UPS/Rectifier

AlphaPowerSystem-MIB:dcPwrSysAlarmActiveTrap 

dcPwrSysAlarmTriggerValue.9 = 10024 
dcPwrSysTimeStamp.9 = 2020/10/20 07:17:09 
dcPwrSysSiteName.9 = rect01.roc​h 
dcPwrSysRectAlrmSeverity.9 = 0 
dcPwrSysRectAlrmIndex.9 = 9 
dcPwrSysRectAlrmStringValue.9 = Rect. AC Mains Fail 
snmpTrapOID = AlphaPower​System-MIB:d​cPwrSysAla​rmActiveTr​ap 
sysUpTime = 1 hour 0 minutes 11.36 seconds 

Kbr0125

when creating the custom alert on the web Orion, it will keep triggering my alert email because the query still sees the entry in the database. Is there a way to delete the entry or compare it against a current date or something so if its older than 5min it will not retrigger the event.

I kind of have the bellow working, it now sends out a AC main lost email, then when i plug back in after time, it sends a restored, but it will send back another AC main lost email and 1 more restore.

Trigger Even:

WHERE Nodeid IN (SELECT nodeid FROM traps
	INNER JOIN trapvarbinds tv
	ON traps.trapid = tv.trapid
WHERE traptype = 'AlphaPowerSystem-MIB:dcPwrSysAlarmActiveTrap'
	and traps.DateTime > dateadd(minute, -1 ,getdate())
	AND tv.OIDValue = 'Rect. AC Mains Fail'
)

Reset Condition:

WHERE Nodeid IN (SELECT nodeid FROM traps
	INNER JOIN trapvarbinds tv
	ON traps.trapid = tv.trapid
WHERE traptype = 'AlphaPowerSystem-MIB:dcPwrSysAlarmClearedTrap'
	and traps.DateTime > dateadd(minute, -1 ,getdate())
	AND tv.OIDValue = 'Rect. AC Mains Fail'
)

With these, i get the first email, then when i return power and get the clear trap, it will send the restore email. It will then send a power fail again for a 2nd time, then a restore for a 2nd time, then a fail a 3rd time then a restore a 3rd time. Then the alarm is fully reset, if that makes sense.