cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Level 9

Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi all,

I have a custom property called 'Region' that is assigned to nodes depending on which global region they're in (UK, EMEA, APAC etc.) I'd like to filter the "Top Ten Interfaces by Percent Utilisation" list so that it only shows interfaces on nodes that have the custom property 'Region' set to 'UK'. Under the Filter Interfaces section, I've tried various things, but the syntax I'm using must be wrong. I thought "Node.Region = 'UK'" would work but it doesn't.

I hope this is an easy one to solve 🙂

Thanks in advance

ollydrew

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Level 12

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi,

if your filter is Node.Region='UK', it can not work as the table name is Nodes. Simply change the SQL filter to Nodes.Region='UK'.

Jiri

View solution in original post

0 Kudos
8 Replies
Highlighted
Level 13

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Try this out in the filter Interfaces section.It should work.

Region='UK'

0 Kudos
Highlighted
Level 9

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi Nandish,

I tried that and it doesn't work. System returns "Custom SQL filter is incorrectly formated ."

Can I try anything else?

0 Kudos
Highlighted
Level 13

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Here is a series of steps.

1.To add the custom property Region,
 Open Start-->Solarwinds Orion-->Grouping and access control-->Custom Property editor-->Add custom property-->check "region" field
2.Bring up the Orion and select the Node from the Summary page.
3.Select "Edit Custom Property Values" option under the 'Custom Properties for Nodes' section
4.Name the region.example 'UK'
5.Repeat this for all the Nodes
6.Select Home-->Top10 and look for "Top10 Interfaces by Percent Utilization"
7.Select Edit and under Filter Interfaces.Give Region='UK'

0 Kudos
Highlighted
Level 13

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Would you like to try this.

Region like '%UK%'

Just in case you might have left any space before or after naming in the region data field.

 

And also just review the steps mentioned above and let us know how different is it from yours.

0 Kudos
Highlighted
Level 9

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi Nandish,

Region like '%UK%' doesn't work either I'm afraid.

I also tried following the steps you provided, but I don't undestand Step 2. Can you explain further?

Also, regarding Step 5, have hundreds of nodes, so I'd rather not have to repeat this process hundreds of times.

ollydrew

0 Kudos
Highlighted
Level 13

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi OllyDrew,

I would like to see a screen shot of "Custom Property for Nodes" from the Custom Property editor.(You may blur out the important information in the screen shot,I mainly want to see the Region field)

How did you import the file in brief?

Thx

0 Kudos
Highlighted
Level 12

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Hi,

if your filter is Node.Region='UK', it can not work as the table name is Nodes. Simply change the SQL filter to Nodes.Region='UK'.

Jiri

View solution in original post

0 Kudos
Highlighted
Level 9

Re: Top Ten Interface Percent Utilization custom filter

Jump to solution

Thank you JiriPsota - your filter did the trick!

0 Kudos