Filter Nodes (SQL) Question

1. I am trying to list Top 10 Interfaces which are not bond0 interfaces in this example "Filter Nodes (SQL)": InterfaceName Not Like 'bond0'

2. The same example when you use regex in "Filter Nodes (SQL)": InterfaceName Not Like '*ond*'

My above post was to filter out interfaces, but then from what I understand as per your requirement you don't want to view interfaces related to certain nodes, to achieve this you will have to use the columns available in Interface Table.

As per your requirement -> " I would like to use a "Filter Nodes (SQL)" statement to report on all nodes *except* for nodes with a name of *map* (map is in middle of their names) OR nodes with a name of *123* for example. " You can use the below filters:

1. FullName Not Like '*map*'

2. FullName Not Like '*123*'

FullName will contain node name+ interface name under Interfaces Table, hence the above filters will work as expected.

Hope this helps, let me know how it goes.

If its Report Writer that you are taking about - create a Advanced SQL report to extract the same report and use the below query:

Note: MODIFY THE SELECT query accordingly. The below query is just an example

SELECT

Nodes.Caption AS NodeName, Interfaces.Caption AS Interface_Caption, Interfaces.HighPercentUtil AS High_Percent_Utilization

FROM

Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)

WHERE 

(

  (Nodes.Caption NOT LIKE '%map%')

)

Thanks very much - that's what I needed!

One last question - what's the proper OR statement if I want to do a series of them?

Example:

FullName Not Like '*map*' OR FullName Not Like '*123*'

This is incorrect - trying to find out how to join multiple OR statements together

Thanks again!

this is always true

e.g.:

123 is not like '*map*' or 123 is not like '*123*' = true or false = true

map is not like '*map*' or map is not like '*123*' = false or true  = true

EITHER

123 is not like '*map*' AND 123 is not like '*123*' = true AND false = false

map is not like '*map*' AND map is not like '*123*' = false AND true  = false

OR

NOT ( 123 is like '*map*' or 123 is like '*123*' ) = not( true or false) = false

NOT ( map is like '*map*' or map is like '*123*' ) = not( true or false) = false

Thank you!  Perfect!

I realise this is an old post, but I am having similar issues.  I would to show all nodes that don't contain the words "BMS".  I have used the following SQL, but it status the syntax is incorrect.  Please can you help.

FullName Not Like '*BMS*'

the SQL wildcard character is a '%', not a '*'

try

FullName Not Like '%BMS%'