SWQL filter syntax examples for SAM
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.
propertyNameExample 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