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

More SQL Filter Syntax fun

BryanBecker

In the Orion in the down interfaces view the follwing filters will not work :

Status = 2

Interface.Status = 2

They get an error :

Custom SQL filter is incorrectly formated.

Interface.Status = 2 works in EOC.

What am I missing? I don't want unmanaged stuff to show up.

Find more posts tagged with

Accepted answers

sedmo

Try interfaces.status

All comments

sedmo

Try interfaces.status

BryanBecker

That worked...again the documentation is not correct then.

Rane

Documentation and support have been sub-par from Orion since we started and its gone downhill ever since.

RogerWong

Bryan, I'm working on a guide to fix the frustrating gaps in the filtering documentation. I'm writing new material and gathering related information into one place so that no one has to go looking in three different places to create a working filter query. Thanks for being so patient as we fix this.

CuppaT

Hi Roger,

Is there any update on the documentation you were compiling?

I'm having 'fun' converting - Where

VolumeType LIKE 'Fixed Disk' AND Caption NOT LIKE '%Memory' AND Caption NOT LIKE '/%'

- so it is recognised in NPM for a view!