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.
Yeah so effectively I need to do an SQL script which will be something like below example:
Select Job_names where success = ‘0’ and timestamp > 1 hour ago
Then I need to display those results in a dashboard so the team can identify which jobs have failed within the last hour so the team know which ones to investigate, rather than the current view of just how many jobs have failed.
Thanks
Jonny
