The most recent content from our members.
Hi, I'm able to create Custom SQL alerts on Solarwinds based on Trap Type, thanks to the previous posts in the this forum and especially detailed responses from RichardLetts on various questions in particular! But looks like the requirements that we have is bit more complex. The 'Trap Type' is going to be the same in our…
This is an overly simplified guide for "Keep the lights on" SQL to "Expert" SQL users wanting to jump into SolarWinds Query Language (aka Orion API) as fast as possible. Who can use SWQL? * Any user that has web credentials to the web console can use those credentials to run scripts. What is SWQL? * Orion SWQL or…
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…
The new log manager product logs to the table dbo.events messages like "Message from syslog dropped since 1.1.1.1 is not monitored on engine xxxxxxx" 1 - People with view limitations wont see this event as the node might be theirs, but they are not admins 2 - People dont tend to look at the events list like they do Active…
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…
We recently installed UDT to get rogue device alerts on our environment, but are a little disappointed in the same thing a lot of others have noted elsewhere in Thwack. We have to have alerts but we don't care about people on our guest wifi, which it doesn't let us segregate. I went through the devices found in the rogue…
Hi all I want to use a custom propertie value in the alert email action To address field. That has been discussed before and you can just add a variable there to get the address. BUT I want to add some logic there and therefor add a custom SQL variable. I got one that is working perfectly in the message body but Orion say…
I have a SNMP TRAPS requirement from Database team. I have tried several solutions posted on Thwack but none of them has the same requirement. Facts Source Server: Same for All traps Traps: Different Trigger: Reset: No Reset Condition (Prefer: No reset condition – Trigger this alert each time the trigger condition is met)…
We are doing a Alert Trigger condition using Custom SQL Alert. Here is the following code: I want to alert on: Custom SQL Alert (Advanced) Set up your SQL condition: Node SELECT Nodes.NodeID, Nodes.Caption FROM Nodes , (SELECT * FROM ntta_monitor_alert_procedures WHERE alert_procedure = 'no-email' AND AlertName =…
Hi Guys, I am relatively new to Solarwinds and I'm trying to set up an alert using an SQL condition. The end goal is to send out alerts for when we receive this trap 'BGP4-MIB:bgpTraps.0.2'. This is what im using as the SQL condition to trigger the alert: "select * from [dbo].[Traps] WHERE Hostname IN ('Router1','Router2')…
It looks like you're new here. Sign in or register to get started.