3 Replies Latest reply on Nov 29, 2013 9:07 AM by BakerD

Chart Interface Filters

BakerD Nov 29, 2013 8:34 AM

I'm trying to filter on a Top 10 Interfaces by Percent Utilization Chart. I"m getting the error Custom SQL filter is incorrectly formatted when trying to use Caption Like '*MPLS*'.

Here is an example of one of my interfaces listed under the interface column, FastEthernet0/0/0 · MPLS.

My goal is to just show data links on my routers for our MPLS cloud. Some are serial interfaces with a single T1, some are bundled T1 Multilink interfaces and some are ethernet. I don't want to see all the fastethernet, gigabit etc type interfaces.

Thanks

Re: Chart Interface Filters

BakerD Nov 29, 2013 8:45 AM (in response to BakerD)

I opened up the DB Manager on the server and the below works giving me a list.

SELECT TOP 10 * FROM [dbo].[Interfaces]
where Caption Like '%MPLS%'

I see in my original post I was using *, but when I changed to % I still get the same error, but it seems to work in DB manager.
Like Show 0 Likes(0)

Actions
Re: Chart Interface Filters

LadaVarga Nov 29, 2013 8:56 AM (in response to BakerD)

Could you please try:

Interfaces.Caption Like '*MPLS*'
Like Show 0 Likes(0)

Actions
- Re: Chart Interface Filters
  
  BakerD Nov 29, 2013 9:07 AM (in response to LadaVarga)
  
  That works as well as using FullName Like '*MPLS*' by itself.
  
  Thanks
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post