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?