The most recent content from our members.
To create a query to alert on a flapping routing protocol. First, for the Alert Engine, we need to Alert on nodes so we have to design a SQL query to return NodeId we can use the NPM_RoutingTable_Flap so that we also have the FlappingId to allow a count We also want to be able to identify the Protocol we are interested in…
We are trying to monitor two air conditioners in a data center. They run alternating one week on, one week standby and it is not unusual for the AC that is on standby to go above 30 degrees. Therefore, I need to create an alert that goes as follows: IF AC Running = Yes AND IF Temp > 30 degrees = Yes THEN Create alert I…
With some SQL commands to create an alert on flapping Nodes. Important for this is also how often you poll the Nodes Status !!! Trigger Condition: Set up on Node In the Alert select custom SQL When you select Node it preselects this statement SELECT Nodes.Caption, Nodes.NodeID FROM Nodes In the SQL condition please paste…
I have a bunch of Custom SQL Alerts set up. Most of them are not having any issues, but i am having an issue with custom pollers. I noticed that we haven't had any alerts going off so i went into the alert and copied the query and ran it in MSSQL and the query returned results. I did some troubleshooting then i opened a…
ATTN: Case #836227 I'm having a bear of a time getting this one to work, so I am hoping someone in the community might have some insight into what is making my SQL macro barf all over me. I'm monitoring file system space on a PILLAR NAS, and in my alert, I need to show what file system is running out of space. If I hard…
Hello, I have created an alert that will notify the necessary team members if there are over 50 nodes down, but I have ran into some issues. I have already opened a support case and they recommended that I reach out here. The general flow of this alert is that if there are 50 nodes down at a given time the alert will…
We have a cluster of 6 machines and we are monitoring the same process on each machine. We would like an alert to be generated only if 4/6, 5/6, or 6/6 components fail. How would this be possible?
Hi, I'd like to trigger an alert based on two conditions: * Custom poller 1 is equal to 'x' AND * Custom poller 2 is equal to 'y' when I look at the SQL query generated it is absolutely not what I want: SELECT DISTINCT CustomPollerAssignmentView.CustomPollerAssignmentID AS NetObjectID,…
Let me clear my scenario more briefly. Let us suppose if parent went down .. for example Firewall. In that case what will happen, we will get bunch of emails showing that firewall is down, and other alerts will speak of devices went unreachable. The emails will be as many as the child notes went unreachable. Can I get a…
I am pretty new to using the SQL variable in the advanced alert manager. I know we can define our own custom SQL queries in the trigger actions like email. I have a large event message I'd like to get just the body of information from. Is this possible or is the ${SQL:} variable not capable of this?
It looks like you're new here. Sign in or register to get started.