This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Advanced alert possible to do sql query?

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?