SQL Filter Syntax Examples

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'

Examples

Example filter to show only Cisco devices: Vendor = 'Cisco'

Example filter to show data only from component monitors named Server Load Monitor: Monitor.Name like 'Server Load Monitor'

Example filter to show data from devices beginning with "AX3": Node.Caption Like 'AX3*'

Example filter to show only Nortel devices that are Down: Vendor Like 'Nortel*' AND Status=2

Filtering by Status

To filter by the status, you must know the valid status levels:

Level

Status

0

Unknown

1

Up

2

Down

3

Warning

14

Critical

Example filter to only show monitors that are not down: MonitorStatus.Availability<>2