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 Nodes Exclusions

While using the Filter Nodes option in Custom View, how can I include certain results while excluding others in the same query. For instance, I want to setup a query to show me all of x, but exclude if value y is present.

I can use 'AND' and 'OR', but what is the operative for excluding?

Any help would be appreciated...

- Chris

Find more posts tagged with

Accepted answers

All comments

Network_Guru

Chris,

Have you tried using the filters in Report Writer?
Once you have created a filter that works for you, click on the show SQL tab under Report.
Then you can copy and paste this query into the Custom Properties editor.

Here is an exclude example created with report writer:

WHERE
( DateTime BETWEEN 37592 AND 37958 )
AND
(
(Nodes.Vendor = 'Cisco') AND
(Nodes.Caption LIKE 'ON%') AND
(
NOT (Nodes.Caption LIKE '%xxON%'))
)

This shows all Cisco nodes beginning with ON but not if they contain xxON.

-=Cheers=-
NG

cshiver

Thanks for the helpful response. I'd been trying to use 'NOT' but'AND NOT' was the key to excluding in the filter query. Works great now!

- Chris

RogSchmidt

we do that kinda thing for our customers too. but we do it a little different. we added custom properties named 'country' and 'customer_id' to each node and then entered the information for each customer's routers.

then in the orion web site, we limit each customer's account to only see their devices using the 'customer_id' property and have seperate views for each country with filters on 'all nodes' and custom grouping by country. we also run reports now by country that groups by customer_id.

rog

Network_Guru

I agree Rog.

With the custom properties editor, it is much easier to filter views based on user defined info in a custom field. I have created a "type" field for filtering reports.
Now I use BB for Backbone interfaces, Wan for serial WAN interfaces, UL for LAN interswitch trunks and links, etc. Previously, I was inserting characters such as $, !, etc. in front of the interface descriptions for filtering my utilization reports.

This custom property editor is one of the best things to happen to Orion.
Now we have the Customer contact info for each node right on the node details web page.
It's great!

-=Cheers=-
NG

BakerD

I have created a custom property and the only place I can see it is in the custom property tool. I have populated the new field with info. Shouldn't I be able to see this new field in the system manager when I look at node details?

Thanks

PS Also if I open up the database, I see that the column has been added and the info I put in the column.

Network_Guru

The custom property fields can be used in Report Writer, or displayed on the web pages,
but do not appear in System manager. They can also be used for web account limitation
and grouping nodes.

System manager only displays information collected from SNMP queries of your devices, and any aliases you have added to the node or interface name.

-=Cheers=-
NG

iunderwo

You have to select the property to be visible. You can add them manually, but they won't show up unless you select the checkbox in the resource.

// Ian Underwood - Service Management
// Level 3 Communications