Top XX Interfaces by Percent Utilization Filter

str4nd

Hi,

I am struggling with a problem, regarding filters on Top XX Interfaces by Percent Utilization.

I would like to remove access ports from our switches, and only see trunk ports.

I have tried to use the following without any luck:

NodePortInterfaceMap.PortType = 2

NodePortInterfaceMap points to the table in the SQL Database and PortType is the column.

/ Henrik

Find more posts tagged with

npm_top_xx_interfaces_by_utilization_filter

npm filter

Accepted answers

janene16

I think Top xx Interfaces by Percent Utilization is actually using Interfaces table, not the NodePortInterfaceMap table that's why the query does not work.

Why not just create a custom property for your trunk ports and use this instead? You can use the filter:

Interfaces.YourCustomProperty = 'YourCustomPropertyValue'

All comments

janene16

I think Top xx Interfaces by Percent Utilization is actually using Interfaces table, not the NodePortInterfaceMap table that's why the query does not work.

Why not just create a custom property for your trunk ports and use this instead? You can use the filter:

Interfaces.YourCustomProperty = 'YourCustomPropertyValue'

cabeza

Am trying to filter a particular interface type from top XX interfaces, how to do that?

janene16

Simple. use InterfaceTypeName as filter.

same format: your_database_table.the_column_name

Best to check Interfaces table from your database to see what best suits you for your view

cabeza

thanks for the update, actually am looking to remove particular type of interfaces from being listed in Top XX, so am looking for an option like,

"Caption" or "Interface type" is not equal to "Tunnel", how can I achieve this?