Hi

The image above shows the trap i need to get into the Event list on Orion NPM.
"spSensorValue = 1" should be the Trigger Condition, and "spSensorValue = 0" is the Reset Condition.
I have tried to make a custom sql alert, but can't get it right.
Can someone help me on this one?
Thanks,
Simon
UPDATE:
Case is closed, this is the solution:
Trigger Condition:
INNER JOIN traps a
ON a.nodeid = nodes.nodeid
INNER JOIN trapvarbinds b
ON a.trapid = b.trapid
AND b.oidname = 'spSensorValue'
WHERE a.traptype = 'HHMSAGENT-MIB:spUnknownStatus.301'
AND a.datetime >= Dateadd(second, -15, Getdate())
AND b.oidvalue = '1'
Reset Condition:
INNER JOIN traps a
ON a.nodeid = nodes.nodeid
INNER JOIN trapvarbinds b
ON a.trapid = b.trapid
AND b.oidname = 'spSensorValue'
WHERE a.traptype = 'HHMSAGENT-MIB:spUnknownStatus.301'
AND a.datetime >= Dateadd(second, -15, Getdate())
AND b.oidvalue = '0'
Big thanks to .