Filter Interface query

dpillar

In our Top XX bandwidth Interfaces by Percent utilization we want to limit to only certain interfaces. Our current query looks like this

 

mapview = 'summit'  and InterfaceName like 'Serial%' or InterfaceName like 'Gigabit%' or InterfaceName like 'ppp%'

We created at custom Properties called TopXXInterBy_Util that is yes or no.

Question: how can we change our query to just show interfaces with only TopXXInterby_Util that have yes configured?

Thanks in advance

David

cahunt

IT should show as a custom property to use so you can filter using the SQL Query box when you click edit for the 'Display All Interfaces' Module or whatever report you have created.

TopXXInterby_Util = 'Yes'  

Try something like this.

((mapview = 'summit'  and (InterfaceName like 'Serial%' or InterfaceName like 'Gigabit%' or InterfaceName like 'ppp%')) AND TopXXInterby_Util = 'Yes')