Comments
-
You can use SQL wildcards in alert conditions definition, because from each condition is created SQL statement. In condition definition have to be "contains" as operator and SQL will use LIKE in SQL condition. If you want to use "NOT LIKE" you can define "Trigger Alert when none of the following apply" Now you can use SQL…
-
I'm glad to hear that. Thanks for information, have a nice day!
-
Hi, you could try following SQL query: SELECT TOP 10000 DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,'20000101',[DateTime])/5.0)*5,'20000101') AS SummaryDate, Interfaces.FullName AS Full_Name, MIN(InterfaceTraffic.In_Minbps) AS MIN_of_Minimum_Receive_bps, AVG(InterfaceTraffic.In_Averagebps) AS AVERAGE_of_Average_Receive_bps,…
-
wakhan, any update here? Can I help with something?
-
Hello, there is problem with inner operations like CREATE TABLE or INSERT. Report writer isn't able to handle these results. Fix is very easy: put as first statement in your SQL query: SET NOCOUNT ON Which prevents to return results from inner operations (e.g.: "Command(s) completed successfully."). So your SQL should look…
-
Hi wakhan, How to capture packets: Download WireShark from: http://www.wireshark.org/download.html Run it and in Capture option configure: Select network interface on the server thru which NTA receives the flows In 'Capture filter' put: 'udp port 2055 and src 11.110.2.1' Select file into which you want to capture the…
-
In this case you can use following SQL statement. Before you execute that, backup please your NetPerfMon database or at least table ActionDefinitions. Statement change "From E-Mail Account" on email actions from nobody@nobody.com to required name and email. Change bold text to name and email which you want to use: UPDATE…
-
Hello, Is acceptable to use Advanced SQL Report for you? If so, it couldn’t be a big problem to create report for your Warning and Critical alerts by appropriate SQL statement like that: SELECT S.TriggerTimeStamp, D.AlertName, S.ObjectName as MachineName FROM AlertStatus S JOIN AlertDefinitions D ON (S.AlertDefID =…
-
Hello, please could you post screenshot with that issue? And only for sure, this issue appeared just after NTA hotfix, right? No any other update was applied (IIS, Core, NPM, ...)? Thanks.
-
Behavior: Received 10 traps in 1 minute--> Execute Action & Suspend for 15 minutes 15 minutes elapsed --> Wait for new 10 traps in 1 minute Received 10 traps in 1 minute--> Execute Action & Suspend for 15 minutes 15 minutes elapsed --> Wait for 10 new traps in 1 minute This logic repeat again and again.
-
Hello, please could you describe me what exactly you need to change on all alerts? I think there is way by write specific SQL update which I can write for you - if it will be technically possible. Is it for all alerts or only for some alerts? In case only for few is there something same (like word in name, ...)? Thanks.
-
Hello, please which version of NTA do you have? According to this stack trace it seems as older version than latest 3.8. I recommend to update to 3.8 where we addressed and fixed issues related to the Reporting. Is it possible to upgrade to 3.8? Thanks, Ondrej
-
Hello, it should works as you expect. Which version of Orion do you have? I verified this behavior on 9.5 SP4. Time from rule is compared against time on the computer where SolarWinds Syslog Service is running.
-
Hello, from NTA point of view: Generally good for "Keep compressed data for X days" is to set depth which you require for your charts. So when you satisfied with last 2 weeks, set this value to 14 days and you improve performance of your system. If you require more than default 30 days for your charts, set more - but be…
-
Hi, your understanding is correct and here is explanation how we collapse data from time point of view: The service periodically checks if conditions for collapsing are met (if elapsed required time since last collapsing and if there are any data to collapse), if so the collapsing begins. So the time when collapsing is…
-
Hello, we are sorry for this issue. We found bug when TOP XX IP Address Groups are on Interface Details and NTA is upgraded to 3.8. But we have two simple ways how to fix it: 1. Upgrade to 3.8 and then run following SQL script on your Orion DB: UPDATE Resources SET ResourceFile =…
-
Hello, at this moment it's not possible without code change. But you can create trigger in DB for Acknowledged column in AlertStatus table and then send email from MS SQL: support.microsoft.com/.../312839 www.motobit.com/.../ It’s not clear, but it should works without touching the code. Warning: This solution could have…
