References > References > Filter syntax reference and navigation > SolarWinds SAM SWQL resource matrix

SolarWinds SAM 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.

SolarWinds SAM resources

Resources for SolarWinds Server & Application Monitor (SAM) use a mix of SWQL and SQL filters. Tables that start with APM_ are SQL tables and use SQL filters. The remaining are SWIS tables and use SWQL filtering.

SAM Resource Table Name SWQL Alias
All Applications Tree Orion.APM.Application Application
Orion.APM.ApplicationTemplate ApplicationTemplate
Orion.APM.CurrentApplicationStatus Status
Orion.Nodes Nodes
Applications with Problems Orion.APM.Application Application
Orion.APM.ApplicationTemplate Template
Orion.APM.CurrentApplicationStatus Status
Orion.Nodes Nodes
Top XX Components by Statistic Data APM_CurrentComponentStatus MonitorStatus
APM_PortEvidence pe
APM_ComponentExt Monitor
APM_Application Application
APM_CurrentApplicationStatus ApplicationStatus
APM_ThresholdsByComponent thresholdRT
APM_ThresholdsByComponent thresholdStat
APM_ErrorCode ec
APM_StatusCodeType sct
APM_StatusCode sc
Top XX Components by Response Time APM_CurrentComponentStatus MonitorStatus
APM_PortEvidence pe
APM_ComponentExt Monitor
APM_Application Application
APM_CurrentApplicationStatus ApplicationStatus
APM_ThresholdsByComponent Threshold
Top XX Processes by CPU Load APM_CurrentComponentStatus MonitorStatus
APM_PortEvidence pe
APM_ComponentExt Monitor
APM_Application Application
APM_CurrentApplicationStatus ApplicationStatus
Top XX Processes by Physical Memory APM_CurrentComponentStatus MonitorStatus
APM_PortEvidence pe
APM_ComponentExt Monitor
APM_Application Application
APM_CurrentApplicationStatus ApplicationStatus
APM_ThresholdsByComponent Threshold
Top XX Processes by Virtual Memory APM_CurrentComponentStatus MonitorStatus
APM_PortEvidence pe
APM_ComponentExt Monitor
APM_Application Application
APM_CurrentApplicationStatus ApplicationStatus
APM_ThresholdsByComponent Threshold