What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

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

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



3 Replies

Votes:

0

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

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



Votes:

0

Have also tried added EXEC usp to the COMMENTS tab

Created on Jul 13, 2011 8:14:37 AM




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.