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

Error Status Codes Saved for Failure Events?

Are the Error Status Codes for APM Component failures saved in the database for each component failure that occurs? If so, where can I find this historical data?

Thanks in advance for any help on this.

Find more posts tagged with

Accepted answers

All comments

Hello Byron,
there are two tables for two monitor types - APM_PortEvidence_Detail and APM_ProcessEvidence_Details. Process evidence is for process monitors (WMI and SNMP) and there is just [ErrorCode] column witch won't be much useful for you.

All other monitors have records in APM_PortEvidence_Detail table and there is [ErrorMessage] column that contains message as you can see it on component details page in "Component Status Details" row on "Component Details" resource.

To get corresponding component, you have to join to APM_ComponentStatus_Detail table using [ComponentStatusID] and to APM_Component table using [ComponentID]. For example:

SELECT c.Name,   p.ErrorMessageFROM [APM_Component] c JOIN [APM_ComponentStatus_detail] d  ON c.ID = d.ComponentIDJOIN [APM_PortEvidence_Detail] p  ON p.ComponentStatusID = d.ID

Quick Links