Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017September13 - EOC > SWQL resource matrix

SWQL resource matrix

Created by Anthony.Rinaldi_ret, last modified by Gerald.Prado on Sep 13, 2017

Views: 146 Votes: 0 Revisions: 6

This resource matrix helps you find the SWQL aliases you need to create filter criteria for your resources. The following tables are organized by resource type.

Alert resources

Resource SWIS Entity Name SWQL Alias

Global Last XX Active Alerts

EOC.Alert2

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Alert

Node

Node.CustomProperty

SWServer

Triggered Alerts for All Network Devices

EOC.Alert2

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Alert

Node

NodeCustomProperty

SWServer

Events resources

Resource SWIS Entity Name SWQL Alias

Global Events Summary

EOC.Event

EOC.EventType

EOC.Orion

Event

EventType

SWServer

Global Last XX Events

EOC.Event

EOC.EventType

EOC.Node

EOC.Orion

Event

EventType

Node

SWServer

Inventory resources

Resource SWIS Entity Name SWQL Alias

Number of Interfaces by Type

EOC.Interface

EOC.Orion

I

SWServer

Number of Nodes by Device Type

EOC.Node

EOC.Orion

Node

SWServer

Number of Nodes by IOS/OS

EOC.Node

EOC.Orion

Node

SWServer

Groups resources

Resource SWIS Entity Name SWQL Alias

Global Active Group Alerts

EOC.Alert2

EOC.Orion

Alert

SWServer

Global All Groups

EOC.Groups

EOC.Orion

EOC.StatusInfo

Groups

SWServer

StatusInfo

Global Groups With Problems

EOC.Groups

EOC.Orion

Groups

SWServer

EOC resources

Resource SWIS Entity Name SWQL Alias

Global Top XX Errors & Discards This Hour

EOC.Interface

EOC.Node

EOC.Orion

I

N

SWServer

Global Top XX Error & Discards Today

EOC.Interface

EOC.Node

EOC.Orion

I

N

SWServer

Global Top XX Interfaces by percent utilization

EOC.Interface

EOC.Node

EOC.Orion

I

N

SWServer

Global Top XX Interfaces by Relative Multicast Packet Rate

EOC.Interface

EOC.Node

EOC.Orion

I

N

SWServer

Global Top XX Interfaces by Traffic

EOC.Interface

EOC.Node

EOC.Orion

I

N

SWServer

Global Top XX Nodes by Average Response Time

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Nodes by CPU Load

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Nodes by Current Response Time

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Nodes by Percent Memory Used

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Nodes by Percent Packet Loss

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Volumes by Disk Space Used

EOC.Node

EOC.Orion

EOC.Volume

EOC.Volume.Stats

N

SWServer

V

VS

IPAM resources

Resource SWIS Entity Name SWQL Alias

Global Top XX DHCP Scopes by Utilization

EOC.IPAM.GroupNode

EOC.Orion

Scope

SWServer

Global Top XX Subnets By % IP Address Used

EOC.IPAM.GroupNode

EOC.Orion

Subnet

SWServer

NCM resources

Resource SWIS Entity Name SWQL Alias

Global Configuration Manager Nodes

EOC.NCM.Nodes

EOC.Node

EOC.Orion

NCMNode

Node

SWServer

Global Devices Backed Up vs Not Backed Up

EOC.NCM.ConfigArchive

EOC.NCM.Nodes

EOC.Node

EOC.Orion

ConfigArchive

NCMNode

Node

SWServer

Global Last XX Config Changes

EOC.NCM.CacheDiffResults

EOC.NCM.ComparisonCache

EOC.NCM.Nodes

EOC.Node

EOC.Orion

CacheDiffResults

ComparisonCache

NCMNode

Node

SWServer

Global Policy Violations For Each SolarWinds Server

EOC.NCM.LatestPolicyReportViolations

EOC.NCM.PolicyReports

EOC.Orion

LPR

PR

O

NTA resources

Resource SWIS Entity Name SWQL Alias

Global Last XX Traffic Analysis Events

EOC.EventType

EOC.Node

EOC.Orion

EventType

Node

SWServer

Global NetFlow Sources

EOC.Interface

EOC.Interface

EOC.NetFlow.Source

EOC.NetFlow.Source

EOC.Node

EOC.Node

EOC.Orion

I

I1

S

S1

N

N1

SWServer

NetFlow Collector Services

EOC.NetFlow.Engine

EOC.Orion

S

SWServer

NetFlow Traffic Analyzer SWQL Queries

Top XX Apps

  • F.ApplicationName
  • F.MapTo --> string [portnumber (multiport for unmonitored)]
  • Orion. --> for orion server related variables

Top XX Countries

  • F.CountryCode
  • F.CountryName

Top XX Protocols

  • F.ProtocolID
  • F.ProtocolName

Top XX Endpoints

  • F.HostName

Top XX Conversations

  • F.SourceIP
  • F.SourceHostname
  • F.DestinationIP
  • F.DestinationHostname

SAM resources

Resource SWIS Entity Name SWQL Alias

Global All Applications

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

A

AT

CAS

N

NodeCustomProperty

SWServer

Global Application Health Overview

EOC.APM.Application

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

Application

Status

Node

SWServer

Global Applications by Status

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

A

AT

CAS

N

NodeCustomProperty

SWServer

Global Applications with High Process CPU Load

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

SWServer

Global Applications with High Process Memory Used

EOC.APM.Application

EOC.APM.CurrentApplicationStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CAS

CS

N

SWServer

Global Applications with High Response Time

EOC.APM.Application

EOC.APM.CurrentApplicationStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CAS

CS

N

SWServer

Global Applications with Problems

EOC.APM.Application

EOC.APM.ApplicationTemplate

EOC.APM.CurrentApplicationStatus

EOC.Node

EOC.Orion

A

AT

CAS

N

SWServer

Global Top XX Components by Response Time

EOC.APM.Application

EOC.APM.Component

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

Monitor

CCS

CS

N

SWServer

Global Top XX Monitored Processes by CPU Load

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

SWServer

Global Top XX Monitored Processes by Physical Memory

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

SWServer

Global Top XX Monitored Processes by Virtual Memory

EOC.APM.Application

EOC.APM.CurrentComponentStatus

EOC.APM.CurrentStatistic

EOC.Node

EOC.Orion

A

CCS

CS

N

SWServer

Total Applications By Type for Each Local SolarWinds Server

EOC.APM.ApplicationTemplate

EOC.Orion

AT

SWServer

UDT resources

Resource SWIS Entity Name SWQL Alias

Global Total Ports Currently Used

EOC.Orion

SWServer

Top XX Nodes by Percent Ports Used

EOC.Node

EOC.Orion

EOC.UDT.NodeCapability

EOC.UDT.NodeStatistics

N

SWServer

S

NS

VNQM (IP SLA) resources

Resource SWIS Entity Name SWQL Alias

Global Active IP SLA Operation Alerts

EOC.AlertDefinition

EOC.AlertStatus

EOC.IpSla.Operation

EOC.IpSla.OperationType

EOC.Orion

AlertDefinition

AlertStatus

IpSlaOperation

IpSlaOperationType

SWServer

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

SWServer

Global Last XX IP SLA Events

EOC.Event

EOC.IpSla.Event

EOC.Orion

Event

IpSlaEvent

SWServer

Global Top XX All Operations

EOC.IpSla.Operation

EOC.IpSla.OperationCurrentStat

EOC.IpSla.OperationStatus

EOC.IpSla.OperationType

EOC.IpSla.Site

EOC.IpSla.Site

EOC.Node

EOC.Node

EOC.Orion

IpSlaOperation

IpSlaOperationCurrentStat

IpSlaOperationStatus

IpSlaOperationType

SourceSite

TargetSite

SourceNode

TargetNode

SWServer

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

SWServer

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

SWServer

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

SWServer

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

SWServer

L

S1

S2

D

Global Top XX VoIP Call Paths

EOC.Node

EOC.Node

EOC.Orion

EOC.Voip.Link

EOC.Voip.Site

EOC.Voip.Site

EOC.Voip.UdpResultDetail

N1

N2

SWServer

L

S1

S2

D

Global VoIP Call Managers

EOC.Node

EOC.Orion

EOC.Voip.CCMStatistic

N

SWServer

C

Global VoIP Collector Services

EOC.Orion

EOC.Voip.Engine

SWServer

S

Global VoIP Sites Overview

EOC.IpSla.Operation

EOC.IpSla.OperationCurrentStat

EOC.IpSla.OperationStatus

EOC.IpSla.Site

EOC.Node

EOC.Orion

L

D

OperationStatus

S

Node

SWServer

WPM resources

Resource SWIS Entity Name SWQL Alias
Global All Locations

EOC.SEUM.Agent

EOC.Orion

A

O

Global All Transactions

EOC.SEUM.Transaction

EOC.Orion

T

O

Global Steps With Problems

EOC.SEUM.TransactionStep

EOC.Orion

EOC.SEUM.Transaction

EOC.StatusInfo

EOC.StatusInfo

TS

O

T

s

s2

Global Top XX Steps by Duration

EOC.SEUM.TransactionStep

EOC.Orion

TS

O

Global Top XX Transactions by Duration

EOC.SEUM.Transaction

EOC.Orion

T

O

Global Transaction Health Overview

EOC.SEUM.Transaction

EOC.Orion

EOC.StatusInfo

T

O

S

Global Transactions With Problems

EOC.SEUM.Transaction

EOC.Orion

EOC.StatusInfo

T

O

S

Summary Report resources

Resource SWIS Entity Name SWQL Alias

Global Down Interface

EOC.Interface

EOC.Node

EOC.Orion

I

Node

SWServer

Global Down Nodes

EOC.Node

EOC.Orion

Node

SWServer

Global High Errors & Discards Today

EOC.Interface

EOC.Node

I

N

Global Node Status by Site

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Node

NodeCustomProperty

SWServer

Global Nodes with High CPU Load

EOC.Node

EOC.Orion

Node

SWServer

Global Nodes with High Memory Utilization

EOC.Node

EOC.Orion

Node

SWServer

Global Nodes with High Packet Loss

EOC.Node

EOC.Orion

Node

SWServer

Global Nodes with High Response Time

EOC.Node

EOC.Orion

Node

SWServer

Global Top XX Nodes with Problems

EOC.Node

EOC.Node.CustomProperty

EOC.Orion

Node

NodeCustomProperty

SWServer

Global Volumes with High Percent usage

EOC.Node

EOC.Orion

EOC.Volume

N

SWServer

V

SolarWinds Servers Summary Statistics

EOC.Orion

SWServer

Syslog resources

Resource SWIS Entity Name SWQL Alias

SysLog Messages from All Network Devices

EOC.Node

EOC.Orion

EOC.SysLog

EOC.SysLogFacility

EOC.SysLogSeverity

Node

SWServer

SysLog

SysLogFacility

SysLogSeverity

Syslog Summary

EOC.Orion

EOC.SysLog

SWServer

SysLog

Trap resources

Resource SWIS Entity Name SWQL Alias

Global Trap Resource

EOC.Orion

EOC.Trap

SWServer

Trap

Traps from All Network Devices

EOC.Node

EOC.Orion

EOC.Trap

EOC.TrapVarbind

Node

SWServer

Trap

TrapVarBind

Wireless resources

Resource SWIS Entity Name SWQL Alias

Global Wireless Clients

EOC.Node

EOC.Orion

EOC.Wireless.Interface

N

SWServer

WI

Global Top XX Wireless APs by Client Count

EOC.Node

EOC.Orion

EOC.Wireless.Interface

N

SWServer

WI

Global Top XX Wireless Clients by Traffic

EOC.Node

EOC.Orion

EOC.Wireless.Client

N

SWServer

WC

Last modified

Tags

Classifications

Public