Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Use node filters

Use node filters

Updated March 6, 2018


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.


NPM 12 and later


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 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'


Last modified