Hi everyone, I have follow the topic about "Node grouping with a Tree View" and that works as I want but... with one small problem. In fact, I want to filter a node list by name and take all node with the name wich contains "fw" (firewall) for example... All our nodes are marked like that : . But there is an exception. The last of the 3 letters of a land node and the first letter of the node type make a "fw". Is-it possible to insert some "joker characters" like in SQL ? For example : SELECT * FROM atab WHERE afield LIKE "???fw#" (I'm not sure of my SQL command ;o) ). Thanks in advance for your attention.

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

Another problem with Node grouping

Hi everyone,

I have follow the topic about "Node grouping with a Tree View" and that works as I want but... with one small problem.

In fact, I want to filter a node list by name and take all node with the name wich contains "fw" (firewall) for example... All our nodes are marked like that : letters for the land><2-3 letters for node type><...>. But there is an exception. The last of the 3 letters of a land node and the first letter of the node type make a "fw".

Is-it possible to insert some "joker characters" like in SQL ?

For example : SELECT * FROM atab WHERE afield LIKE "???fw#" (I'm not sure of my SQL command ;o) ).

Thanks in advance for your attention.

Find more posts tagged with

Accepted answers

jbaulsir

How about

Caption Like 'oxffw*' or Caption Like 'abcfw*' and Caption Not Like 'defwan*'

All comments

SamuelB

Geolem,

Does the following example work for you?

Caption Like '*FW*'

Geolem

Hello

I have all ready test this and that works... but, when you have a router named oxfwan01, Orion take it too.

I just want that Orion take nodes like oxffw01 or abcfw01 and not defwan01.

To solve my problem, there is another issue ? In fact I have a lot of nodes with the same Vendor (firewall, wan router, switch, ...) and I would like to separate theses nodes. I considered the solution above. Have you got an another solution ?

Very thanks

craig999

Note sure how many Firewalls you have, but could you use a custom property for the firewalls? And just display based on the custom property?

jbaulsir

How about

Caption Like 'oxffw*' or Caption Like 'abcfw*' and Caption Not Like 'defwan*'

Geolem

Note sure how many Firewalls you have, but could you use a custom property for the firewalls? And just display based on the custom property?

I have tried after your answer and it works very great. It's perfect, but... It's a heavy work to do. If there isn't another solution, I do that for all nodes...

Geolem

How about
Caption Like 'oxffw*' or Caption Like 'abcfw*' and Caption Not Like 'defwan*'

JB

I would like to keep the "grouping" like the file attached.

orion_views.gif

Geolem

In fact to summarize the problem, I have All Nodes grouped by Vendor and I would like to group all nodes with a part of nodes captions.

To transform the first image to the second image...

Thanks

orion_views2.gif

qle

Based on the two nodes you mentioned, how about:

Caption Like '*fw01'

assuming they all end the same. Otherwise, JB sounds like he was on the right track. Just define it further as follows:

Caption Like '*fw*' and Caption Not Like '*fwan*'