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

HTTP Historical Status Details

When an APM HTTP has failed but is now OK I want to be able to report on the reason for that historical failure (i.e. DNS Lookup, HTTP402, etc) I can find this status info in the DB but I can't figure out how to index it properly so that I reference the right component and the right time frame. Has anyone done this ? In case the tables/columns have changed I'm running NPM 9.5

Find more posts tagged with

Accepted answers

All comments

jiri.tomek

Hello Ralph,
error message is stored in [APM_PortEvidence_Detail].[ErrorMessage] column. Once it is aggregated to hourly or daily, it is lost. In this table there is [ComponentStatusID] column that points to [APM_ComponentStatus_Detail].[ID]. There you can find [ComponentID] column that points to [APM_Component].[ID]. There is also [TimeStamp] column in [APM_ComponentStatus_Detail] that tells you when error occurred.

You can write custom SQL query for report that joins all these tables to get required data.

Ralphr

Thanks Jiri,

Realize as you roll up data you can not keep a record of each error instance but as a future feature request it would be helpful to have at least a count of each error code correlate to the component monitor. For example it would be nice when generating a report on Last Month's Availability of Web URL #1 to show that the Availability was 99% with 3 DNS lookup failures and 1 HTTP404 error or something along those lines...