Documentation forOrion Platform

Filter nodes in Orion Platform widgets using SQL queries

This topic applies to all Orion Platform products.

When you are managing or monitoring large numbers of network devices, node list widgets can easily become very large and difficult to navigate. Filters are optional SQL queries that are used to limit node list displays for easier navigation in widgets. SQL queries can be made on any predefined or custom properties.

  1. Click Edit in any node list widget.

  2. Provide an appropriate SQL query in the Filter Nodes (SQL) field, and click Submit.

    To display query examples in the widget, click Show Filter Examples in the Edit widget view.

    To display the list of properties that can be used in custom filters, click Show List of Node Properties in the expanded Examples section.

SQL query examples

By default, node lists 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.

The following are valid status levels:

Value Status Description
0 Unknown The 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.

 

Copy

Show only Cisco devices

Vendor = 'Cisco'

 

Copy

Show only devices in Austin

This assumes that you have added a custom property called City.

City = 'Austin'

 

Copy

Show only devices with name beginning with AX3-

Caption Like 'AX3-*'

 

Copy

Show only Nortel devices that are down

Vendor Like 'Nortel*' AND Status=2

 

Copy

Show only devices with name ending in -TX

Vendor Like '*-TX'