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