Alerting and Reporting
Wildcards
The wildcard character in SQL syntax is: *.
Example: Node.Caption Like 'AX3*'
Filtering by Custom Property
The property syntax to filter by custom property is:
dataType.CustomProperty.propertyName
Example filter to only show nodes with the custom property City that matches
Atlanta:
Node.CustomProperty.City = 'Atlanta'
Filtering by Status
To filter by the status, 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
Built-in SQL Node Properties
Nodes.Caption Nodes.NodeID Nodes.Status
SWQL Syntax
Some resources allow you to filter data using the SWQL syntax described below.
99
To Next Page
Loading...