Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

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

Use node filters

Updated March 6, 2018

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.

Environment

NPM 12 and later

Steps

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

Tags

Classifications

Public