Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > User Device Tracker (UDT) > UDT Administrator Guide > Alert and Report > SWQL Syntax

SWQL Syntax

Created by Steven Bansil_ret, last modified by Steven Bansil_ret on Jan 23, 2017

Views: 69 Votes: 1 Revisions: 2

Some resources allow you to filter data using the SWQL syntax.

Wildcards

The wildcard character in SWQL syntax is: %.

Example: Node.Caption Like 'AX3%'

Filter by custom property

The property syntax to filter by custom property is:

dataType.CustomProperties.propertyName

Example filter to only show nodes with the custom property City that matches Atlanta:

Node.CustomProperties.City = 'Atlanta'

Filter by built-in properties

Many properties have the same name between data types. To prevent ambiguity, SolarWinds UDT prefixes the property names with the data type.

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

Filter 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

Built-in SWQL Nodes Properties

Node.AvgResponseTime

Node.CPULoad

Node.Caption

Node.Contact

Node.DNS

Node.Description

Node.GroupStatus

Node.IOSImage

Node.IOSVersion

Node.IPAddress

Node.LastBoot

Node.LastSync

Node.Location

Node.MachineType

Node.MaxResponseTime

Node.MemoryUsed

Node.MinResponseTime

Node.NodeID

Node.ObjectSubType

Node.OrionID

Node.PercentLoss

Node.PercentMemoryUsed

Node.ResponseTime

Node.Severity

Node.Status

Node.StatusDescription

Node.SysName

Node.SysObjectID

Node.SystemUpTime

Node.TotalMemory

Node.Vendor

Node.VendorIcon

 

 
Last modified
20:23, 22 Jan 2017

Tags

Classifications

Public