0 Replies Latest reply on Nov 21, 2017 1:31 PM by jvaughan@connectria.com

    Custom Node Poller - Custom SQL Alert not firing

    jvaughan@connectria.com

      Greetings all!

       

      I am trying to set up a Custom SQL Alert for a Custom Node Poller with no luck.  When I modify the query in SSMS to guarantee one returned record, I get nothing in SolarWinds.  I'll attach the real trigger condition and the modified condition that guarantees at least one returned record.

       

      Original query:

      [GIVEN SELECT]

      SELECT CustomPollerAssignmentView.AssignmentName, CustomPollerAssignmentView.CustomPollerAssignmentID FROM CustomPollerAssignmentView

      [CUSTOM]

      LEFT OUTER JOIN (

           SELECT NodeID, COUNT(*) AS 'ProcCount'

           FROM AssetInventory_ProcessorView

           GROUP BY NodeID

           ) AS procs ON CustomPollerAssignmentView.NodeID = procs.NodeID

      WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min'

           AND CONVERT(decimal,CustomPollerAssignmentView.CurrentValue) < procs.ProcCount

       

      Modified to guarantee at least one returned record:

      [GIVEN SELECT]

      SELECT CustomPollerAssignmentView.AssignmentName, CustomPollerAssignmentView.CustomPollerAssignmentID FROM CustomPollerAssignmentView

      [CUSTOM]

      LEFT OUTER JOIN (

           SELECT NodeID, COUNT(*) AS 'ProcCount'

           FROM AssetInventory_ProcessorView

           GROUP BY NodeID

           ) AS procs ON CustomPollerAssignmentView.NodeID = procs.NodeID

      WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min'

       

      It's strange because if I just use WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min', no alerts are triggered.  Is this method of alerting not working as expected, or am I misconfiguring it?

       

      Thanks in advance!

       

      Jack Vaughan, Jr.

      Systems Monitoring Engineer

      ___________________________

      CONNECTRIA HOSTING

      jvaughan@connectria.com

      ___________________________

      NO JERKS ALLOWED®
      www.connectria.com
      Connectria Blog
      Recommend us on Linkedin
      Follow us on Twitter

      nojerksallowed.com