References > Filter Syntax Reference > SAM resources for queries

SAM resources for queries

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. All the others 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