simoneidem

YES PLEASE!

Thanks! Now it worked just fine! Simon

What i need is to create an event when there comes a syslog message containing 'LOOPGUARD_BLOCK'. I tried with this custom SQL alert: Inner join syslog on syslog.nodeid=nodes.nodeid WHERE message LIKE '*LOOPGUARD_BLOCK*' AND datetime > Dateadd(hour, -1, Getdate()) But it did not work. Neither did this one: WHERE nodeid IN…

Hi Richard Could you help me with a similar case: http://thwack.solarwinds.com/thread/59316 Thanks, Simon

Thanks alot, Richard! I did some customization of your examples, and now it works perfect for our use. 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 >=…

Got it! For the record, here is how I did it: --- SELECT EventTime, Message FROM Orion.Events WHERE Message LIKE '%EXAMPLETEXT%' ORDER BY EventTime DESC --- Simon

You are not alone on this! Have spent a LOT of time trying to figure out how to get spesific syslog messages into the event list, with no luck. This simple alert action would do the job in like 15 sec.

Thanks! Did exactly the same "mistake". This saved the day.