Forum Discussion

Kelemvor's avatar
Kelemvor
Icon for Expert rankExpert
2 years 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
Shack's avatar
Shack
Icon for Advisor rankAdvisor
2 months ago

Would returning the strings to datapoints using textmatch work?  Your datapoint descriptions could contain information on what the various strings mean.

TextMatch
Look for presence of a string (TextMatch) tests whether a string is present within the raw output. This method supports regular expressions for text matching. If the string exists, it returns 1, otherwise 0.

 

Stephen_C's avatar
Stephen_C
Icon for Neophyte rankNeophyte
28 days ago

Unfortunately this wouldn't work for me. The text in the string returned varies. The mere fact that a string is returned indicates a problem, and the actual string contains the particular record information.