How do I filter multiple Interfaces from the High Percent Utilization list? (i.e how do I compose the SQL string)

eloyramirez

How do I filter multiple Interfaces from the High Percent Utilization list? (i.e how do I compose the SQL string)

I see there is a list of SQL fitler examples, but I am not a SQL person and I do not know how to make a string with multiple InterfaceID's. I attached a screenshot to explain where I am looking this issue.

...also...my apologies if I put this in the wrong discussion area...this is using NPM 10.2.2

thanks!

NPM.HighPercentage.Filter.Thwack.png

njoylif

if you have a list of interface IDs:

interfaceid not in (1111,2222,3333)

if interface names follow a standard naming convention (where you want all of them ignored)

caption not like '*highlyUtilized*'

you can also also do both by putting them together with "and" in the middle

interfaceid not in (1111,2222,3333) and caption not like '*highlyUtilized*'