Documentation forServer & Application Monitor
Monitoring your applications and environment is a key capability of SolarWinds Observability Self-Hosted (formerly Hybrid Cloud Observability) and is available in the Essentials edition. Server & Application Monitor (SAM) is also available in a standalone module.

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