Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Custom SQL query for an alert

i am trying to get a syslog alert fired when a sql query is matched. I can see the traps coming through the NPM and want a syslog alert when this happens.

I created the below sql query but it doesn't work. if I test it , it works fine, but its not matching the trap

also, wanted to know how to negate this as well

see the below query.

tnms sql query.PNG

thank for your help

Find more posts tagged with

Accepted answers

All comments

HolyGuacamole

Take a look at this

Warning about custom SQL alerts (reset trigger)

You may want to move your query in the Alert lab forum

vinay.by

Hi du243‌ , the above mentioned alert will not work as you running them against 'Node Table' , when you are building a Custom SQL Alert you will have to consider the fields that are linked with the tables on DB accordingly. If not you will have to work with Joins to get them.

Note: Your alert is against Node -> "Set up you Trigger Query : Node" and you have 'Trap Type' on your Where Clause which is running against the Nodes table. This is the reason it isn't working.

Fine tune the alert accordingly.

vinay.by

If this is a trap that you are talking about, get onto your primary poller (Open: Trap Viewer). You can set up alerts for the incoming Traps from there.

Hope it helps