SWQL Filter Syntax Examples

Wildcards

The wildcard character in SWQL syntax is: %.

Example: Node.Caption Like 'AX3%'

Filtering by Custom Property

The property syntax to filter by custom property is:

dataType.CustomProperties.propertyName

Example filter to only show nodes with the custom property City that matches Atlanta:

Node.CustomProperties.City = 'Atlanta'

Filtering by Built-in Properties

Use the SWQL table name for selecting properties for your queries.

Examples

Example filter to show data from Cisco devices: Node.Vendor = 'Cisco'

Example filter to show data from Windows Server 2003-2008 applications: Application.Name = 'Windows Server 2003-2008'

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

Example filter to show data from Process Monitor – SNMP type component monitors: Monitor.ComponentType = 8

Filtering by Status

To filter by the status property, 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