Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Custom SQL query of APM data

Hello,

I am trying to write a custom query to retrieve all values of a given APM component over time. I have been able to retrieve the current values in the view dbo_APMCurrentStatistics but can't find the previous values. I have looked in (I think) every view and table with 'APM' in the name, but can't find the data.

Anyone?

Thanks!

Find more posts tagged with

sql

apm

Accepted answers

Capt._Obvious

try this:

SELECT TOP 10000 APM_AlertsAndReportsData.ComponentName AS Component_Name,

APM_ResponseTime.StatisticData AS StatisticsData,

APM_ResponseTime.DateTime AS DateTime

FROM APM_AlertsAndReportsData

INNER JOIN APM_ResponseTime ON

(APM_AlertsAndReportsData.ComponentId = APM_ResponseTime.ComponentID) WHERE

(APM_AlertsAndReportsData.ComponentName = 'changethis') --change this to the component name

All comments

Capt._Obvious

Use the view APM_reportsandalertsdata instead of the tables

waxxworx

Hi thanks but that view seems to only have a single value per component per node for the most recent timestamp. I'm still not finding historic timestamps.

Capt._Obvious

the tables that have the most recent information will end with "Detail" you may have to make a join statement or two...

Capt._Obvious

try this:

SELECT TOP 10000 APM_AlertsAndReportsData.ComponentName AS Component_Name,

APM_ResponseTime.StatisticData AS StatisticsData,

APM_ResponseTime.DateTime AS DateTime

FROM APM_AlertsAndReportsData

INNER JOIN APM_ResponseTime ON

(APM_AlertsAndReportsData.ComponentId = APM_ResponseTime.ComponentID) WHERE

(APM_AlertsAndReportsData.ComponentName = 'changethis') --change this to the component name