New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

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

 

Top Tags


View all Tags


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

Votes:

0

Your Vote:

Up

Down

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 by  logletho (0) 1



1 Reply

Votes:

0

Your Vote:

Up

Down

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]



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.