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

Filter problems

pjohansen

Trying to filter interfaces in view Top XX Interfaces by Percent Utilization like by below

(FullName LIKE '*Satcom*' OR FullName LIKE '*Satcom*') AND (FullName LIKE '*Seadrill*' AND FullName LIKE '*sdrl-*')

This does not work and it seems to ignore the second parentheses filter.

Also when doing

Alias LIKE '*Satcom*' as a filter the web interface gives me “Custom SQL filter is incorrectly formated.”

Pål

Find more posts tagged with

Accepted answers

tomas.mrkvicka

You are right, you can use even * character - we replace it for % character. I have just tried that condition and it works fine.

Regarding condition "Alias LIKE '*Satcom*'" - there is no such field like Alias, you should use InterfaceAlias.

All comments

pjohansen

Should be

(FullName LIKE '*Satcom*' OR FullName LIKE '*Radiolink*') AND (FullName LIKE '*Seadrill*' AND FullName LIKE '*sdrl-*')

tomas.mrkvicka

Hi,

it seems to me like this condition is little bit weird. You want to have Fullname containing Satcom or Radiolink and you want also to have Seadrill inside it.

Btw. shouldn't you use % instead of character *?

pjohansen

Actually its the description of the interface, so I want all interfaces that has the word "Satcom" or "Radiolink" and "Seadrill" in it to show on the page.

Above query should list all our Satellite links and Radio links interfaces belonging to company Seadrill automatically to view

Btw. shouldn't you use % instead of character *?
Both * and % works the same, but the % is the correct one for db queries. Examples on the page uses * as wildcard though, not sure why.

We have a lot of sites moving around to different teleports and just by using the correct description on the routers interface page will be updated and no need for manual adding/removing interfaces from view.

tomas.mrkvicka

You are right, you can use even * character - we replace it for % character. I have just tried that condition and it works fine.

Regarding condition "Alias LIKE '*Satcom*'" - there is no such field like Alias, you should use InterfaceAlias.