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

SWQL Custom Alert, Triggered Condition

I am changing a currently in use custom alert triggered with the following condition: specific nodes that use the specific custom poller that hit 30c or higher will trigger an alert.

The below query works and is valid but now I want it to be used on all nodes that use the custom poller. The condition needs to change to: all nodes that use the specific custom poller that hit 30c or higher will trigger an alert.

Inner Join Orion.NPM.CustomPollerAssignment cpa on cpa.NodeID = Nodes.NodeID
Inner Join Orion.NPM.CustomPollerStatus cps on cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID
Where cpa.CustomPollerID = 'e6a6c65b-8a84-4b9c-a87c-23999fa30b4e' and cps.status >=30 and (cpa.NodeID = 491 or cpa.NodeID = 716 OR cpa.NodeID = 540 OR cpa.NodeID = 473 OR cpa.NodeID = 460)

Trying to Remove "and (cpa.NodeID = 491 or cpa.NodeID = 716 OR cpa.NodeID = 540 OR cpa.NodeID = 473 OR cpa.NodeID = 460)" from the query but keep getting "Query condition is not valid."

Basically, I am trying to use this more broadly all nodes and not on specific nodes.

Find more posts tagged with

SWQL

Accepted answers

sum_giais

Ok that's a conversion issue possibly. Might need to grab the raw status from another field or just put single quotes around the 30, e.g. >= '30' because the value from the database may be a string.

All comments

mesverrum

Maybe a stray character when you edited it or something weird in your browser session that a restart might fix, because i copied your query and it tests as valid for me.

ThePriceIsRIGHT

The attached picture is what I am presented. I have tried on different browsers and computers.

Screenshot 2020-09-30 at 1.34.01 PM.png

shuth

That query works for me.

ThePriceIsRIGHT

I have tried the below but still unable to get the code valid. if there are any suggestions for fixing this or an alternative way to code this I am all ears. Thanks in advance to anyone that helps me figure this out.

ThePriceIsRIGHT

Its still not working, any thoughts?

mesverrum

I would second the suggestion from above to install swql studio on your server and test it there since the error messages in swql studio are much more specific. I can't see any reason why the query is not working for you but has no issues for the rest of us.