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

Advanced SQL alert Incomplete trigger?

I am trying to deploy a custom alert that will warn us when the temperature on a cisco device raises above the set threshold. Working from the database my SQL query works, but when I try to put it into advance alert manager I get an error message that Please specify a complet trigger condition field not specified or invalid?

here is my query

Select nodes.nodeid as netobjectid, nodes.caption as name
From nodes join CustomPollerAssignment as cpa on cpa.nodeid = nodes.nodeid
join custompollerstatus as cps on
cpa.custompollerassignmentid = cps.custompollerassignmentid
join custompollers
on cpa.custompollerid = custompollers.custompollerid
where cpa.custompollerid = '{61A9A17E-29FC-4077-9367-A3114B48E23B}' and cps.rawstatus<
all (Select cps.rawstatus
From CustomPollerAssignment as cpa1
join custompollerstatus as cps on
cpa1.custompollerassignmentid = cps.custompollerassignmentid
join custompollers
on cpa1.custompollerid = custompollers.custompollerid
join nodes on cpa1.nodeid = nodes.nodeid
where cpa1.custompollerid = '{5089234C-1420-4E85-8A26-C6CE2799D612}'
and cpa.nodeid = cpa1.nodeid
)

Find more posts tagged with

Accepted answers

All comments

nelsonc0

Not sure what I done different, but created a new alert today with the same sql statement copy/pasted and it worked?

Questionario

When I read your post I thought maybe our implementation will help others too...

this only works on cisco devices which support the mentioned OID's though