Forum Discussion

Kelemvor's avatar
Kelemvor
Icon for Expert rankExpert
11 months ago

Can LM run a SQL Query against a specific Server/Database and alert based on the results?

Hi, I had a request for this today, but I've never done anything like this, so I'm not sure If it's possible or how to do it. The original request was to run a certain query and create an alert if ...
sql
Anonymous's avatar
Anonymous
11 months ago

I would have them modify the query to return account and use that count as a data point. That way the alert would stay open as long as the count is non-zero. 

https://github.com/sweenig/monitoring-recipes/tree/master/DataSources/Groovy/JDBC