SQL filter syntax examples for SAM
Wildcards
The wildcard character in SQL syntax is:
*
.Example:
Node.Caption Like 'AX3*'
Filtering by Custom Property
Use the following syntax to filter by custom property is:
dataType.CustomProperty.propertyName
For example, to only show nodes with a custom property City that matches Atlanta, use
Node.CustomProperty.City = 'Atlanta'
Examples
To show only Cisco devices:
Vendor = 'Cisco'
To show data only from component monitors named "Server Load Monitor":
Monitor.Name like 'Server Load Monitor'
To show data from devices beginning with "AX3":
Node.Caption Like 'AX3*'
To show only Dell devices that are Down:
Vendor Like 'Dell*' AND Status=2
Filtering by Status
To filter by the status, here are valid status levels:
Level Status 0
Unknown
1
Up
2
Down
3
Warning
14
Critical
For example, to only show monitors that are not Down, use
MonitorStatus.Availability<>2