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

Nodes Not Up Filter Nodes (SQL) HELP

I am trying to filter the Dashboard Nodes Not Up section.

I don't want to see any of the Nodes that are Unmanaged so I put in (UnManaged = 0) and it is working great but I also want to NOT show Nodes that I have named with the word RAP at the end. It represents our Remote Access Points. They go up and down all the time. I don't want to remove then from the system but just not show them in the list here. I have tried (NodeID not like '*RAP'), (SysName not like '*RAP') and Description not like '*RAP'. Nothing works. What is the Name of the Property? Is my syntax correct? and to do both would I pit it as something like UnManaged = 0 OR NodeID not like '*RAP' or is there another way?

Thank You

For your help!

Find more posts tagged with

Accepted answers

vinay.by

Try this

UnManaged = 0 AND Caption not like '*RAP*'

All comments

jbemp

Well I figured out part of it myself the Field is "Caption" so Caption not like '*RAP' hides all the Nodes that have the word RAP on the end. Now I need to put the two together.... I tried (Caption not like '*RAP' OR UnManaged = 0) but that shows everything.... Is there some extra syntax that I need to do if a node has either of the two to hide it?

vinay.by

Try this

UnManaged = 0 AND Caption not like '*RAP*'

jbemp

That worked THANX! Kinda strange. I would have thought that would mean is the Node was Unmanaged AND had the word RAP in the Caption..... But anyway its all good. Thanx for your help.