Jonathan Hart

Members
  • Posts

    9
  • Joined

  • Last visited

Reputation

1 Neutral

About Jonathan Hart

  • Rank
    Member
    Member
  1. @Jeroen Gouma Hi, Did you manage to find your notes on this at all? Thanks Jonathan
  2. Thank you! Much appreciated. I will look into it while you search for your notes.
  3. Hello, We are planning to move from Slack to Microsoft Teams and therefore need to look into how we change our Slack integration alerts into MS Teams alerts. Is there any up to date information/instructions on this? TIA.
  4. 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 Jonny
  5. 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 Jonny
  6. 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 Jonny
  7. 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 Jonny
  8. 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 Jonny
  9. 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. Jonny