Using Collector to Run SQL Query.... | Product Discussions

John_Lockie · 2022-03-02T16:30:15Z

We have a custom datapoint we built that runs a basic "select top 1" command to get application exceptions (which the app stores in SQL) from a remote sql server. It appears that LM can only pull down integer data when doing this? In other words, this table we are looking in is for application "ExceptionLog" and has columns for "User", "Severity" and "Title" and "EventID". If any of the columns are anything other than an integer, it returns "No Data" in LM. There are particular service account we want to watch out for - so ideally our query can just "select top 1 User" every few minutes, then configure alert any time user == service account. Is this expected behavior, and has anyone found a workaround for this?

MoreDiscussions

Using Collector to Run SQL Query.... | Product Discussions | LogicMonitor Community