Using Collector to Run SQL Query....
We have a custom datapoint we built that runs a basic "select top 1" command to get application exceptions (which the app stores in SQL) from a remote sql server.
It appears that LM can only ...
Forum Discussion
This is expected behavior for a datasource. Datasources can only return numerical values.
However, you could switch from a JDBC datasource to a scripted datasource (using JDBC) and use groovy to map the possible text values to integers (think error codes).
Although, it sounds like you may do better having a scripted EventSource use JDBC and check. Then you could have the eventsource check all the lines returned for any specific criteria you want and open an alert for each offending line.
