SWQL filter syntax examples
The following sections detail how to filter in SWQL by using the most frequently requested examples.
The wildcard character in SWQL syntax is: %.
Example: NodesData.Caption Like 'AX3%'
Filter by a custom property
The data types that support custom properties are:
Use the SWQL alias for these data types when selecting custom properties for your queries. The property syntax to filter by custom property is:
Example filter to only show nodes with the custom property City that matches Atlanta:
NodesCustomProperties.CustomProperties.City = 'Atlanta'
Filter by built-in properties
Use the SWQL alias when selecting properties for your queries.
Example filter to show data from Cisco devices:
NodesData.Vendor = 'Cisco'
Example filter to show data from Windows Server 2003-2008 applications:
Status.Application.Name = 'Windows Server 2003-2008'
Example filter to show data from devices beginning with "AX3":
NodesData.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.
Example filter to only show monitors that are not down: