Jonathan_Hart
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Move from Slack to MS Teams
2 hours ago, Jeroen Gouma said: Hi Jonathan, This can be done. I will try to find my notes and post them here. Meanwhile, on the LM side you have to create an Integration which posts message to http endpoint. On the MS Teams side you need to create a webhook in the teams-channel which is used by LM to post a message I'll let you know when I found my notes Thank you! Much appreciated. I will look into it while you search for your notes.12Views0likes0CommentsDataSource polls version of an application from a MySQL DB fine but then results in a table widget show as 'NaN'
Hello, I've setup a datasource which queries a MySQL DB to get the version of an application. The datasource shows the result as follows. However when putting this in a dashboard widget it shows as 'NaN' like below: Any help would be appreciated. Thanks JonnySolved40Views0likes2CommentsShow "Output" from the Raw Request/Response in email alerts
I was wondering if it was possible to show the "Output" section of the attached screenshot in either the email alert (in a custom email template maybe?) or in the actual datapoint itself instead of the datapoint being 1=yes 0=no? Any help/advice would be appreciated. Thanks Jonny14Views0likes1CommentRe: IF EXIST statement for a JDBC Alert
2 hours ago, Vitor Santos said: Not sure if I'm understanding it correctly but, I believe if it returns an error it'll abort the operation & return you the exception. My suggestion is to use try, catch (via groovy instead)... to predict those possible scenario(s) & don't abort the script without following the remaining operations. Not sure if this will help you, but, just a suggestion :)/emoticons/smile@2x.png 2x" title=":)" width="20" /> Thanks for the response Vitor, Did a little more digging and found the best way to do it (in this case, not necessarily the best way) was to add DECLARE @SQL NVARCHAR(MAX); and then print @SQL at the end so: --PRINT @SQL EXECUTE sp_executesql @SQL END This then allowed me to use multiple DB names and it wouldn't error when the DB didn't exist for different server. Thanks Jonny1View1like0CommentsIF EXIST statement for a JDBC Alert
Hello, I'm trying to setup an alert that runs a query against an MSSQL DB and in a couple of cases the DB name is different. The intial thought was that I could add IFEXIST (DB name query) then begin a query and then at the end of that query have another IFEXIST (the other DB name query) then begin but this then creates an error saying the DB doesn't exist for the other DB. Example: The error that occurs for the below is when polling the data on server 1 it is saying database 456 does not exist which is correct but i was hoping it would ignore it because of the IFEXIST clause. server 1 has a database called 123 and server 2 has the same database but it's called 456. So I have tried the below: IF EXISTS (select * from sys.databases where name = '123') BEGIN USE 123 SELECT CAST ( ( Select COUNT(*) from table where ARR_TIMESTAMP >= DATEADD(day, -1, GETDATE()) and column LIKE '%flowtype1%' ) AS INT ) AS [flowtype1], CAST ( ( Select COUNT(*) from table where ARR_TIMESTAMP >= DATEADD(day, -1, GETDATE()) and column LIKE '%flowtype2%' ) AS INT ) AS [flowtype2] END; ELSE IF EXISTS (select * from sys.databases where name = '456') BEGIN USE 456 SELECT CAST ( ( Select COUNT(*) from table where ARR_TIMESTAMP >= DATEADD(day, -1, GETDATE()) and column LIKE '%flowtype1%' ) AS INT ) AS [flowtype1], CAST ( ( Select COUNT(*) from table where ARR_TIMESTAMP >= DATEADD(day, -1, GETDATE()) and column LIKE '%flowtype2%' ) AS INT ) AS [flowtype2] END; Any help would be appreciated. Thanks JonnySolved24Views0likes2CommentsRe: Anomaly Detection
15 hours ago, Stuart Weenig said: You can configure Dynamic Thresholds to look for deviations from the norm either positive, negative, or both. Perhaps some more information about what you've tried so we can guide you to something that will fit. Yeah sure, to add a bit more detail - The alert is a simple JDBC collector, runs a script against an SQL DB to get a count of what we refer to as "Flow types". I then have a dashboard for each customer that has a line graph of all the flow types for that customer and shows the counts. On the dashboard an example of one flow type usually ranges from a count of 500-1500 however the anomaly detection "Expected Range" (specifically the lower range) is going down to -500. I'd expect as time goes on the expected range becomes smarter so to say based on the data it recieves? Thanks Jonny2Views0likes0CommentsAnomaly Detection
Hi There, Quite new/inexperienced with LM however I've been looking/testing with the Anomaly Detection feature. Is there a way to set up the Anomaly Detection to only go from a value of 0 upwards? Currently the Anomaly Detection block in the graph is allowing for minus numbers which wouldn't happen in the scenario of my alert. Thanks for any information in advance. Jonny23Views0likes2Comments