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

need help w/syntax for TOP xx - INTERFACE FILTER - EDIT RESOURCE

Habakkuk3_17-19

i have a router which has a multilink made up of three serial t1s.

the multilink plus it's three independent t1s show up in the top 10 util. I want to avoid seeing the serial interfaces.

so since i want to FILTER out those three serial interfaces - how can i do that?

i already have a working FILTER looking like this - but - how do i expand on it to filter out the serials?

Nodes.Caption LIKE 'HQ%' OR Nodes.Caption LIKE 'STATE%'

Also, is there a good resource somewhere on Solarwinds, etc which can expound on using EDIT RESOURCE/FILTER?

I need help with building on these SQL expressions...

Thanks,

Gil

Find more posts tagged with

Accepted answers

All comments

Habakkuk3_17-19

...what can i say? i found the answer myself on MSDN.

if anyone needs a jump start with something like this then let me know.

it deals with SQL 'Predicates' and their order.

timmyz

yeah i would like to know. I have the same issue and could use a little help

thanks

tim

Habakkuk3_17-19

say you have Node names like - Branch1-Rtr or Interface names like - Branch1-Rtr-Serial0 and SmallOffice1-Rtr or Interface names like SmallOffice1-Serial0

when you go into the area of EDIT then go to FILTER NODES (or FILTER INTERFACE) use this syntax:

Nodes.Caption LIKE 'Small%'

Nodes.Caption LIKE 'Small%' OR Nodes.Caption Like 'Branch%'

NOT (Nodes.Caption LIKE 'Small%' AND InterfaceName LIKE 'Ethernet%') AND Nodes.Caption LIKE 'MainOffice%'

There's a special sequence you have to follow with using the LIKE NOT OR AND. I had it written down on my whiteboard, but have erased it since then. i'll try to find that info and repost it for you.

Here's more examples.

NOT VolumeType LIKE 'RAM'

VolumeType LIKE 'Fixed Disk'

These are all FILTER syntax method to either Display or Not Display your results.

I hope this helps.