What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Include TSQL query result set in notfication email

Votes:

0

Your Vote:

Up

Down

As per topic header, is it possible to Include t-ql query result set in notfication email ?

For example:

select * from table1 where condition = x

The monitor prob triggers an alert on any records found. Count > 0. Notification is delivered by email. Is it possible to include the query result in the notification email ?

(I understand this is not the best use of a COUNT trigger as values are ZERO or massive).

Thank you. Scott

email notification results sql t-sql

Created on Jul 12, 2011 3:02:39 PM by  scott_lotus (0) 1



3 Replies

Votes:

0

Your Vote:

Up

Down

Dear Scott,

you can enter the query into the Comments-tab of the sensor and then use the placeholder %comments in the notification to send it out as well.

best regards.

Created on Jul 12, 2011 4:10:12 PM by  Torsten Lindner [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Thank you for the reply.

I selected the SENSOR Select the COMMENTS tab Added the QUERY and saved Loaded SYSTEM & WEBSITE Added the value %comments to the footer. Created an alert

Resutling email contains "select * from table1 where condition = x" in the COMMENTS section and "select * from table1 where condition = x" in the footer.

Is there are way to display the query RESULTS as opposed to the T-SQL statement itself.

Thank you Scott

Created on Jul 13, 2011 7:14:11 AM by  scott_lotus (0) 1



Votes:

0

Your Vote:

Up

Down

Have also tried added EXEC usp to the COMMENTS tab

Created on Jul 13, 2011 8:14:37 AM by  scott_lotus (0) 1



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.