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

Can the SDK be used to extract SAM component statistical data into CSV?

I apologize if this has been asked or if the solution is already well-known.

I just found the SDK today and I'm going through the samples. What I'd like to accomplish is some kind of scheduled data extract of component statistic data into CSV files, other flat file formats, or maybe an archive database. The samples mainly cover grabbing really basic information and performing a few operations on nodes, volumes, etc. I can't find anything like what I'd want to accomplish. Are there any examples of this out there? Like, say, grabbing the last month's worth of data for any component and dumping it to CSV?

Thanks.

Find more posts tagged with

Accepted answers

All comments

rhart-ka

In the Orion SAM database, component statistic data seems to reside in the [APM_PortEvidence_Detail], [APM_PortEvidence_Daily], and [APM_PortEvidence_Hourly] tables according to the configured data retention periods. In the SWQL tool, there is a data structure called

Orion.APM.PortEvidence that appears to return min/max/average statistic values like they exist in the daily, hourly, and detail PortEvidence tables in the database, but doesn't give access to the raw statistic polling data. There are a few views into current component stats and details as well, but they also don't contain what I need. Am I missing anything?

For example, I wrote this SQL (not SWQL) query against the SAM database to return all statistic data for a given ComponentID, assuming the component actually stores statistic data.

select cd.TimeStamp,a.Name,c.Name,apd.StatisticData,cd.Availability,cd.PercentAvailabilityfrom [dbo].[APM_ComponentStatus_Detail] cd inner join dbo.APM_Application a on a.ID=cd.ApplicationIDinner join dbo.APM_Component c on c.ID=cd.ComponentIDinner join [dbo].[APM_PortEvidence_Detail] apd on apd.ComponentStatusID=cd.IDwhere cd.ComponentID=1489 --enter component ID hereorder by cd.TimeStamp desc

derhally

The Orion.APM.PortEvidence and Orion.APM.ProcessEvidence entities should give you access to the detail, hourly and daily data. You will notice that the detail stats will have a RecordCount of 1, while stats that were aggregated into Hourly and daily will be higher.