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 it returns any results. I'm assuming that normally this table is blank, and if there's anything in it, that means something is broken, behind, etc, so they want to know.
I'm guessing we could either treat it like an Eventsource where any results just makes a stand alone alert every time it runs. Or I could have them modify the query to return a Count of results and then maybe set it up like a Datasource with thresholds based on the Count that is returned.
So that brings me to:
- Is something like this possible?
- Does anyone have a tutorial or example on how I'd set something like this up?
I have a lot of experience using LM with the stuff it comes with, but I have little experience creating new source from scratch or doing scripting or anything like that.
Thanks!