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*'
1 of 1 people found this helpful
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.
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?
FullName Not Like '*map*' OR FullName Not Like '*123*'
This is incorrect - trying to find out how to join multiple OR statements together
2 of 2 people found this helpful
this is always true
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
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
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!
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
Nodes.Caption AS NodeName, Interfaces.Caption AS Interface_Caption, Interfaces.HighPercentUtil AS High_Percent_Utilization
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
(Nodes.Caption NOT LIKE '%map%')
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 '*'
FullName Not Like '%BMS%'