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
22 days 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
    17 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.