The most recent content from our members.
Under Managed Alerts, I created a new alert were the Trigger Condition is a "Custom SQL Alert (Advanced)" and the SQL condition is a "Custom Node Poller". However, I was not able to retrieve any data, even when the simplest queries were executed. I could not use SWQL due to the limited functions available. I created a…
This query was originally adapted from jbiggley post in For the purposes of this post and to keep it as simple as possible, I'm trying to create an alert that will identify interfaces that exceed a threshold defined as a percentage of receive discards (.1% for this example). This query works just fine in SQL studio and…
Hi Guys, Recently we created alerts to provide us with BGP Neighbor information I'm having a problem as such as when the SQL Query returns NULL values for neighbors that don't have the IP address in the database, instead of the alert displaying "nothing" if pastes the SQL query in the alert. Is this an issue within NPM or…
lI've had multiple areas I would like to alert on (VIM_Hosts and several others). Unfortunately I've not found a way to do this beyond trying to hit another location (like SNMP). This doesn't always allow me to catch what I'm looking for until after the event. An example I would like to do is - SELECT HostName,…
This is a Default Alert added in 10.1, I have added this in case you somehow did not receive this Alert in the upgrade.
Just a note, not really a question just information for others should they get alerts that are not getting cleared right when using Custom SQL alerts. I made a customer SQL alert and a custom reset SQL alert. It seems like I ran across an issue where the comments were causing a syntax issue. I tested the code many times…
We have a custom SQL alert (well, we actually have a few of them) that does a calculation that uses SAM to capture processor queue length and compare it against the total number of available CPUs plus the actual CPU utilization. (Thanks Leon Adato!) We noticed last week that a bunch of these alerts weren't clearing out…
Hello everyone, I need to create an alert to select ThinAP for which there are more than N (in the example below, 2) clients with ip address 0.0.0.0 for 10 minutes (so dhcp is not working correctly). The standard alerting features for WIFI do not allow to do that, thus I've created a query that works perfectly in sql…
Everytime I change anything in my Alert, which has a 'Type of Property to Monitor' of 'Custom SQL Alert', I get the message box similar to this: Edit Alert Definition You have changed the trigger conditions for this alert. This will clear out any triggered alerts for this alert definition. Do you wish to continue? Yes No…
Hi The image above shows the trap i need to get into the Event list on Orion NPM. "spSensorValue = 1" should be the Trigger Condition, and "spSensorValue = 0" is the Reset Condition. I have tried to make a custom sql alert, but can't get it right. Can someone help me on this one? Thanks, Simon UPDATE: Case is closed, this…
It looks like you're new here. Sign in or register to get started.