0 Replies Latest reply on Jul 18, 2012 2:46 PM by rhugh

    Alerts and SQL queries

    rhugh

      I wrote a script that will disable a syslog alert before I perform a test.  Then I can re-enable the alert after I am done with my testing.  However, this did not work - even though the enable box for the alert is un-checked, I still get the alert.  I found out that for it to work, I would have to restart the syslog service.  If I disable the alert manually (i.e., though the console), the alert will truly be disabled.  So I re-wrote my test to check the Enable flag:  send the alert if the flag is enabled, and don't send the alert if the flag is disabled.  This works when I manually run the script.  However, when I incorporate the same exact script into the alert, the SQL portion that looks up the flag does not get executed.  I am thinking that there is some kind of credential issue here, but I can't figure out what it is.  I have the ODBC set up with the database connection, and a username/password for authentication.  Does anyone know how I can get the localsystem to execute the query?  (Localsystem is what runs the Solarwinds service.)  Any insight would be greatly appreciated.