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 |