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.
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
Dec, 2017 - Permalink