References > Filter Syntax Reference > SWQL Resource Matrix

SWQL Resource Matrix

The resource matrix helps you find the SWQL aliases you need to create filter criteria for your resources. The SWIS entity names are provided so that you know exactly how the SWQL alias maps to the SWIS entities in your SolarWinds product databases.

EOC Filters

All Enterprise Operations Console (EOC) resources use SWQL filtering:

Alert Resource Filters

Resource SQL Table Name SWQL Name

Global Last XX Active Alerts

EOC.Alert2

EOC.Orion

Alert

Orion

SAM Resource Filters

Resource SQL Table Name SWQL Name

Global All Applications

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

Orion

Global Application Health Overview

EOC.APM.CurrentApplicationStatus

EOC.Orion

Status

Orion

Global Applications by Status

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CASN.

N

Orion

Global Applications with High Process CPU Load

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

Orion

Global Applications with High Process Memory Used

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

Orion

Global Applications with High Response Time

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

Orion

Global Down Applications

EOC.APM.Application

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

CAS

N

Orion

Global Top XX Monitors by Response Time

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

AT

CAS

CS

N

Orion

Global Top XX Process Monitors by CPU Load

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

Orion

Global Top XX Process Monitors by Physical Memory

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

Orion

Global Top XX Process Monitors by Virtual Memory

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

Orion

Total Application by Type for Each Local Orion

EOC.APM.ApplicationTemplate

EOC.Orion

AT

O

Events Filters

Resource SQL Table Name SWQL Name

Global Events Summary

EOC.Event

EOC.EventType

EOC.Orion

Event

EventType

Orion

Global Last XX Events

EOC.Event

EOC.EventType

EOC.Node

EOC.Orion

Event

EventType

Node

Orion

Inventory Filters

Resource SQL Table Name SWQL Name

Number of Interfaces by Type

EOC.Interface

EOC.Node

EOC.Orion

I

Node

Orion

Number of Nodes by Device Type

EOC.Node

EOC.Orion

Node

Orion

Number of Nodes by IOS/OS

EOC.Node

EOC.Orion

Node

Orion

EOC Filters

Resource SQL Table Name SWQL Name

Global Top XX Errors & Discards This Hour

EOC.Interface

EOC.Node

EOC.Orion

I

N

Orion

Global Top XX Error & Discards Today

EOC.Interface

EOC.Node

EOC.Orion

I

N

Orion

Global Top XX Interfaces by percent utilization

EOC.Interface

EOC.Node

EOC.Orion

I

Node

Orion

Global Top XX Interfaces by Relative Multicast Packet Rate

EOC.Interface

EOC.Node

EOC.Orion

I

N

Orion

Global Top XX Interfaces by Traffic

EOC.Interface

EOC.Node

EOC.Orion

I

Node

Orion

Global Top XX Nodes by Average Response Time

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Nodes by CPU Load

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Nodes by Current Response Time

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Nodes by Percent Memory Used

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Nodes by Percent Packet Loss

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Volumes by Disk Space Used

EOC.Node

EOC.Orion

EOC.Volume.Stats

N

Orion

VS

IP SLA Filters

Resource SQL Table Name SWQL Name

Global Active IP SLA Operation Alerts

EOC.AlertStatus

EOC.AlertDefinition

EOC.IpSla.Operation

EOC.IpSla.OperationType

EOC.Orion

AlertStatus

AlertDefinition

IpSlaOperation

IpSlaOperationType

Orion

Global All IP SLA Operations

EOC.AlertStatus

EOC.AlertDefinition

EOC.IpSla.Operation

EOC.IpSla.OperationStatus

EOC.IpSla.OperationType

EOC.IpSla.Site

EOC.IpSla.Site

EOC.Node

EOC.Orion

AlertStatus

AlertDefinition

IpSlaOperation

ipSlaOperationStatus

IpSlaOperationType

SourceSite

TargetSite

Node

Orion

Global Top XX Call Paths by Jitter

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

Global Top XX Call Paths by Latency

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

Global Top XX Call Paths by MOS

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

Global Top XX Call Paths by Packet Loss

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

Global VoIP Call Managers

EOC.Node

EOC.Orion

EOC.Voip.CCMStatistic

N

O

C

Global VoIP Call Paths

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

Global VoIP Collector Services

EOC.Orion

EOC.Voip.Engine

O

S

Global VoIP Sites Overview

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

O

L

S1

S2

D

NCM Filters

Resource SQL Table Name SWQL Name

Global Configuration Manager Nodes

EOC.NCM.ConfigArchive

EOC.NCM.Nodes

EOC.Node

EOC.Orion

ConfigArchive

NCMNode

Node

Orion

Global Devices Backed Up vs Not Backed Up

EOC.NCM.ConfigArchive

EOC.NCM.Nodes

EOC.Node

EOC.Orion

ConfigArchive

NCMNode

Node

Orion

Global Last XX Config Changes

EOC.NCM.CacheDiffResults

EOC.NCM.ComparisonCache

EOC.NCM.Nodes

EOC.Node

EOC.Orion

CacheDiffResults

ComparisonCache

NCMNode

Node

Orion

NTA Filters

Resource SQL Table Name SWQL Name

Global Last XX Traffic Analysis Events

EOC.Event

EOC.EventType

EOC.Node

EOC.Orion

EventType

Event

Node

Orion

Global NetFlow Sources

EOC.Interface

EOC.NetFlow.Source

EOC.Node

EOC.Orion

I

S

N

O

NetFlow Collector Services

EOC.NetFlow.Engine

EOC.Orion

S

O

Wireless Filters

Resource SQL Table Name SWQL Name

Global Wireless Clients

EOC.Node

EOC.Orion

EOC.Wireless.Interface

N

O

WI

Top XX Access Points by Number of Clients

EOC.Node

EOC.Orion

EOC.Wireless.Interface

N

O

WI

Top XX Wireless Clients by Traffic Rate

EOC.Node

EOC.Orion

EOC.Wireless.Client

N

O

WC

Summary Report Filters

Resource SQL Table Name SWQL Name

Global Down Interface

EOC.Interface

EOC.Node

EOC.Orion

I

Node

Orion

Global Down Nodes

EOC.Node

EOC.Orion

Node

Orion

Global High Errors & Discards Today

EOC.Interface

EOC.Node

EOC.Orion

I

Node

Orion

Global Node Status by Site

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Node

NodeCustomProperty

Orion

Global Nodes with High CPU Load

EOC.Node

EOC.Orion

Node

Orion

Global Nodes with High Memory Utilization

EOC.Node

EOC.Orion

N

Orion

Global Nodes with High Packet Loss

EOC.Node

EOC.Orion

Node

Orion

Global Nodes with High Response Time

EOC.Node

EOC.Orion

Node

Orion

Global Top XX Nodes with Problems

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Node

NodeCustomProperty

Orion

Global Volumes with High Percent usage

EOC.Node

EOC.Orion

EOC.Volume

N

Orion

V

Orion Summary Statistics

EOC.Orion

O

SysLog Filters

Resource SQL Table Name SWQL Name

SysLog Summary

EOC.Orion

EOC.SysLog

Orion

SysLog

Trap Filters

Resource SQL Table Name SWQL Name

Global Trap Resource

EOC.Orion

EOC.Trap

Orion

Trap

IVIM Filters

All Integrated Virtual Infrastructure Management (IVIM) resources use SWQL filtering:

Virtualization Summary

Resource SQL Table Name SWQL Name

Top 10 VMware Hosts by Percent Memory Used

Orion.VIM.Hosts

Orion.Nodes

h

n

Top 10 VMware Hosts by Network Utilization

Orion.VIM.Hosts

Orion.Nodes

hosts

n

Top 10 VMware Hosts by CPU Load

Orion.VIM.Hosts

Orion.Nodes

h

n

Top 10 VMware Hosts by Number of Running VMs

Orion.VIM.Hosts

Orion.Nodes

hosts

nodes

Datacenter Details

Resource SQL Table Name SWQL Name

Top 10 VMware Hosts by Percent Memory Used

Orion.VIM.Hosts

Orion.Nodes

hosts

nodes

Top 10 VMware Hosts by Network Utilization

Orion.VIM.Hosts

Orion.Nodes

hosts

nodes

Top 10 VMware Hosts by CPU Load

Orion.VIM.Hosts

Orion.Nodes

hosts

nodes

Top 10 VMware Hosts by Number of Running VMs

Orion.VIM.Hosts

Orion.Nodes

hosts

nodes

Cluster Details

Resource SQL Table Name SWQL Name

Top 10 Managed VMware Guests by Current Response Time

Orion.VIM.VirtualMachines

Orion.VIM.Hosts

Orion.Nodes

Orion.NodesStats

vms

hosts

nodes

stats

Top 10 Managed VMware Guests by Percent Memory Used

Orion.VIM.VirtualMachines

Orion.VIM.Hosts

Orion.Nodes

vms

hosts

n

Top 10 Managed VMware Guests by CPU Load

Orion.VIM.VirtualMachines

Orion.VIM.Hosts

Orion.Nodes

vms

hosts

n

Top 10 Managed VMware Guests by Network Usage

Orion.VIM.VirtualMachines

Orion.VIM.Hosts

Orion.Nodes

VM

H

n

SolarWinds SAM Filters

Resources for SAM use a mix of SWQL and SQL filters. Tables that start with APM_ are SQL tables and use SQL filters. All the others are SWIS tables and use SWQL filtering:

SAM Resource Filters

Resource SQL Table Name SWQL Name

All Applications Tree

Orion.APM.Application

Orion.APM.ApplicationTemplate

Orion.APM.CurrentApplicationStatus

Orion.Nodes

Application

ApplicationTemplate

Status

Nodes

Applications with Problems

Orion.APM.Application

Orion.APM.ApplicationTemplate

Orion.APM.CurrentApplicationStatus

Orion.Nodes

Application

Template

Status

Nodes

Top XX Components by Statistic Data

APM_CurrentComponentStatus

APM_PortEvidence

APM_ComponentExt

APM_Application

APM_CurrentApplicationStatus

APM_ThresholdsByComponent

APM_ThresholdsByComponent

APM_ErrorCode

APM_StatusCodeType

APM_StatusCode

MonitorStatus

pe

Monitor

Application

ApplicationStatus

thresholdRT

thresholdStat

ec

sct

sc

Top XX Components by Response Time

APM_CurrentComponentStatus

APM_PortEvidence

APM_ComponentExt

APM_Application

APM_CurrentApplicationStatus

APM_ThresholdsByComponent

MonitorStatus

pe

Monitor

Application

ApplicationStatus

Threshold

Top XX Processes by CPU Load

APM_CurrentComponentStatus

APM_PortEvidence

APM_ComponentExt

APM_Application

APM_CurrentApplicationStatus

MonitorStatus

pe

Monitor

Application

ApplicationStatus

Top XX Processes by Physical Memory

APM_CurrentComponentStatus

APM_PortEvidence

APM_ComponentExt

APM_Application

APM_CurrentApplicationStatus

APM_ThresholdsByComponent

MonitorStatus

pe

Monitor

Application

ApplicationStatus

Threshold

Top XX Processes by Virtual Memory

APM_CurrentComponentStatus

APM_PortEvidence

APM_ComponentExt

APM_Application

APM_CurrentApplicationStatus

APM_ThresholdsByComponent

MonitorStatus

pe

Monitor

Application

ApplicationStatus

Threshold