This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Filter problems

Hi

 

Trying to filter interfaces in view Top XX Interfaces by Percent Utilization like by below

 

(FullName LIKE '*Satcom*'  OR FullName LIKE '*Satcom*') AND (FullName LIKE '*Seadrill*' AND FullName LIKE '*sdrl-*')

 

This does not work and it seems to ignore the second parentheses filter.

 

Also when doing  

Alias LIKE '*Satcom*'  as a filter the web interface gives me “Custom SQL filter is incorrectly formated.”


Pål
Parents Reply Children
  • Actually its the description of the interface, so I want all interfaces that has the word "Satcom" or "Radiolink" and "Seadrill" in it to show on the page.

    Above query should list all our Satellite links and Radio links interfaces belonging to company Seadrill automatically to view

    Btw. shouldn't you use % instead of character *?
    Both * and % works the same, but the % is the correct one for db queries. Examples on the page uses * as wildcard though, not sure why.

    We have a lot of sites moving around to different teleports and just by using the correct description on the routers interface page will be updated and no need for manual adding/removing interfaces from view.

  • You are right, you can use even * character - we replace it for % character. I have just tried that condition and it works fine.

     

    Regarding condition "Alias LIKE '*Satcom*'" - there is no such field like Alias, you should use InterfaceAlias.

  • Thanks, not sure were I got Alias from..