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

SQL resultset in notification email



Hi, is there a possibility to include the SQL resulset within the notification email?

email notification sql

Created on Oct 15, 2013 2:59:29 PM

3 Replies



If the result set is being displayed in the last message field of the sensor you can have this be part of the notification using the placeholder %lastmessage. You can see more placeholders in the KB article here.

Created on Oct 17, 2013 8:56:17 PM by  Greg Campion [Paessler Support]



Sorry, do noct understand what this has to do with my question?

Created on Oct 18, 2013 6:24:41 AM



If you want to have the result set show up in a notification, you would need to use the placeholder %lastmessage in the HTML code for the notification to have PRTG replace that placeholder with the resultset from the sensor. For this you would need to change the HTML for the notification that you want to receive to include that placeholder somewhere.

Edit Notifications

Created on Oct 18, 2013 10:56:48 AM by  Greg Campion [Paessler Support]

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.