scottwe

Thank you, those queries worked for me! One quick edit, needed an additional ) at the end.

Hello, I've tried this solution, even had a healthy snack. This alert is not working for me but I would love to learn how to fix it. SQL validates when I push the button and the email test sends me the text in the message body without substituting data for the variables. One thing I noticed is that my alert and reset…

Thinking about this, I'm wondering if I could take the time stamp from a config (change occurred and we pulled an updated config for RTN), select messages from the syslog db that have a near matching time stamp and parse those messages only to find user information. I might be able to narrow it further by using the…