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.