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

Filter Syntax

I'm having a heck of a time getting the Filter Nodes SQL to work. I want to show in my global nodes only network devices that are down. If I use this :

Node.Vendor = 'Cisco' OR Node.Vendor = 'Juniper*' OR Node.Vendor = 'NetScaler'

It shows only network devices but also ones that are unmanaged.

I tried this :

Node.Vendor = 'Cisco' OR Node.Vendor = 'Juniper*' OR Node.Vendor = 'NetScaler' AND Status=2

And this shows nothing. Do I need to nest this somehow?

Find more posts tagged with

Accepted answers

derhally

If you want to use wildcard comparisons, then you need to use the LIKE operator. Your filter should be written as follows

Node.Vendor LIKE 'net-snmp%'

All comments

BryanBecker

I got it working :

Node.Status = 2 AND Node.Vendor = 'Cisco' OR Node.Vendor = 'Juniper*' OR Node.Vendor = 'NetScaler'

The documentation on the web site needs to be updated...it shows :

Example filter to show nodes from Nortel devices that are Down:

Node.Vendor Like 'Nortel%' AND Status=2

Then just below it is has :

Example filter to only show Nodes that are not UP:

Node.Status<>1

Node.Status is the trick.

RogerWong

Ugh. Sorry about that, Bryan. I will get the example fixed on the web site help.

BryanBecker

Roger....I wanted to go one step further. How would you filter all nodes that are up or down....I don't care about unmanaged devices.

Well...actually I do but if you have an unmanaged device the top of the tree node is yellow. I would expect the only time it would be yellow if a device is down....unmanaged should be ignored...right?

BryanBecker

Roger...can u give me an idea on the global node status and not allowing unmanaged to make the top level yellow?