Network Management

Use node filters in the node list widgets in Orion

This article provides steps on how to use node filters. When managing or monitoring large numbers of network devices, node list resources can become very large and difficult to navigate. Filters are optional SQL queries that are used to limit node list displays for easier resource navigation. SQL queries can be made on any predefined or custom properties.

First published date

10/18/2018 10:52 AM

Last published date

9/30/2022 6:52 PM

Overview

When managing or monitoring large numbers of network devices, you can use filters in node lists to easily navigate the displayed entities. Filters are optional SQL or SWQL queries and can make use of any predefined or custom properties.

Product section

Network Performance Monitor

Cause

N/A

Resolution

To apply a node filter:

  1. Click Edit in any node list widget.
  2. Provide an SQL query in the Filter Nodes (SQL) field. 
  3. Click Submit.
  • By default, node list widgets are designed to sort nodes alphabetically by node caption. This configuration cannot be overwritten using a SQL filter, so Order By clauses included in SQL filters are redundant and will result in Custom SQL filter formatting errors.
  • If you upgraded to Orion Platform version 2015.1.x or later, your custom SQL or SWQL query or filter may no longer work correctly.

Filter by node status

To filter results to only show nodes that are not Up, use Status<>1

Following are valid status levels:

  • 0 = Unknown (current up/down status of the node is unknown)
  • 1 = Up (The node is responding to PINGs)
  • 2 = Down (The node is not responding)
  • 3 = Warning (The node may be responding, but the connection from the server to the Node is dropping packets)

For SWQL examples, see Filtering by status in Use SolarWinds Query Language (SWQL) 

See also:

SQL Filter on Node Category

Use SolarWinds Query Language (SWQL)

SQL query examples 

For SWQL examples, see Filtering by built-in properties or by custom properties in Use SolarWinds Query Language (SWQL).

  • Only show Cisco devices: Vendor = 'Cisco'
  • Only show devices in Atlanta. (Using a custom property named City): City = 'Atlanta'
  • Only show devices beginning with "AX3-": Caption Like 'AX3-*'
  • Only show Nortel devices that are Down: Vendor Like 'Nortel*' AND Status=2
  • Only show devices ending in '-TX': Vendor Like '*-TX'
  • Do not show CD or DVD ROMs: VolumeType != 'CompactDisk