1 Reply Latest reply on Aug 4, 2014 11:19 AM by mharvey

    Custom SQL Alert

    simonp73

      Hi All

       

      how do I get a custom SQL alert to trigger on every trap of a specific type to fire.

       

      I hwritten the SQL script to look in the SNMPtraps.  The alert runs every minute and the SQL has part of the query that looks at the previous minutes worth of alerts, the only problem is that even though the SQL will return several nodes having matching criteria, only a single alert is triggered for one of the nodes.

       

      Am I doing somethign wrong with the script?

       

      Thanks

       

      Simon

        • Re: Custom SQL Alert
          mharvey

          What is the script you are using in the alert?  If you are using an or, then it's going to only select a device once that applies to any of the criteria you are looking at.  For each instance of a trap type, you'd have to have the alert basically reset and retrigger.

           

          Regards,

          Matthew Harvey

          Senior Sales Engineer

          Loop1 Systems