How to return text results from an SQL query
Hello, Relatively new to LM and have been tasked with trying to get a datasource set up that will show all the values in 1 column off the back of a script in MySQL. These values will all be job...
Forum Discussion
Do you just want the names of the jobs but you don’t need to monitor anything about them? In that case, you could use JDBC discovery to create the instances and have a dummy datapoint for monitoring.
Yes, all DataSource monitoring can only do numeric data for collection. But the instances that are being monitored have text based names and can have any number of instance level properties associated with them.
A different route would be a configsource where the configsource script queries the database and returns the data. The goal there would be to just have a blob of text that is monitored for changes. You’d want to make sure that your script outputs the jobs in the same order every time to prevent false alerts indicating a change.
Hello,
Effectively I want to run a MySQL Script that will output job names. For example:
“Select Job_name where success = ‘0’” and timestamp > 1 hour
and then those Job names that are outputted I want to display in some form of widget that shows the support team which jobs have failed so that rather than seeing “jobs failed in last hour = 1” they’ll see the actual job name of what has failed.
Thanks
Jonny
