Jonathan Hart

  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Jonathan Hart

  • Rank
  1. 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
  2. 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.
  3. 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
  4. 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