1 Reply Latest reply on Mar 3, 2009 3:49 PM by jbaulsir

    Advanced alert possible to do sql query?

    sotherls

      I have an advanced alert when a certain threshold (custom property) is passed. I have the contents of the message indicating what the value of the custom property is but I would also like to include the node response time as well.

      The alert message looks like:

      "Outbound circuit utilization is 91%
      Node response time is: $(SQL:select avgresponsetime from nodes where $@Node.nodeid@=414)"

      -----

      The message outputs exactly as above instead of something like:

      "Outbound circuit utilization is 91%
      Node response time is: 103 ms"

      Is this possible, doable?