Chapter 7: Alerting and Reporting
Filtering Data Using Filter Criteria
The following procedure explains how to limit the data sources in a resource by
setting filter criteria in SQL syntax. For more information about the filter syntax,
see “SQL Syntax” on page 75.
To filter node data using filter syntax:
1. Log on to the Orion Web Console.
2. Click the
DEVICE TRACKER
tab.
3. Click
EDIT
on the resource that you want to change.
4. Type your filter criteria in the
Filter Nodes (SQL)
field.
5. Click
SUBMIT
.
SQL Syntax
Some resources allow you to filter data using the SQL syntax described below.
Wildcards
The wildcard character in SQL syntax is:
*
.
Example: Node.Caption Like 'AX3*'
Filtering by Custom Property
The property syntax to filter by custom property is:
dataType.CustomProperty.propertyName
Example filter to only show nodes with the custom property City that matches
Atlanta:
Node.CustomProperty.City = 'Atlanta'
Filtering by Status
To filter by the status, you must know the valid status levels.
Level Status
0
Unknown
1
Up
75
