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 Widget Query

I have a custom down nodes SWQL query that does not show any device with the Caption including imbox:

Caption NOT LIKE '%imbox%'

I need to figure out how to add another NOT LIKE statement for the query. I need to add:

Caption NOT LIKE '%atm%'

But need to keep the imbox statement as well. How do I combine these two in SWQL so it will not show devices with these two captions in the widget but will show all other down nodes?

Find more posts tagged with

custom_swql_query

Accepted answers

gadbekr

I was forgetting the (). Thank you.

All comments

Lofstrand

Like this:

WHERE

    (Caption NOT LIKE '%imbox%' AND Caption NOT LIKE '%atm%')

gadbekr

I was forgetting the (). Thank you.

cnorborg

I prefer to do it like this:

NOT ((Caption LIKE '%imbox%') OR (Caption LIKE '%atm%'))