Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > User Device Tracker (UDT) > Filter nodes in UDT resources

Filter nodes in UDT resources

Created by Steven Bansil_ret, last modified by Steven Bansil_ret on Jan 25, 2017

Views: 148 Votes: 0 Revisions: 2

When you are managing or monitoring large numbers of network devices, node list resources can easily 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. For more information about defining custom properties, see Create custom properties

Apply a node filter

  1. Click Edit in any node list resource.
  2. Provide an appropriate SQL query in the Filter Nodes (SQL) field, and then click Submit.

Example filters with associated SQL queries

By default, node list resources are designed to sort nodes alphabetically by node caption. This configuration can not 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.

  • Filter the results to only show nodes that are not Up:


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

Valid status levels

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