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

Microsoft SQL v2 sensor - storing additional text value in a sensor?



We have many Microsoft SQL v2 sensors measuring metric values from a database. This all works very nicely and the status of each sensor is set by an integer value form the database (eg 3 = Down, 2 = Warn, 1 = OK). The metric value (numerical) is also returned fine from the query and put into a channel in the sensor.

We would also like to return some text that has further descriptive details for a user to give some context to the latest metric value.

How can we store this extra data in the sensor so it could be included in email notifications? We have the text already coming back as another column from the sql query.

channel microsoft-sql-v2 query sensor sql text

Created on Dec 15, 2017 9:49:25 PM

1 Reply



Please check out this post in a related thread. You'll need to modify the query to have the textual value in a seperate column/row of the result table in order to display it as the sensor message.

Kind regards,
Stephan Linke, Tech Support Team

Created on Dec 18, 2017 8:57:29 AM by  Stephan Linke [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.