Group Percentiles Report

Document created by Lutz_Holzbecher Employee on Sep 12, 2017
Version 1Show Document
  • View in full screen mode

This document describes an example to create a custom CSV report for percentiles on aggregated interface metrics at group level.

 

Use Case
A CSV report for a set of groups should list the maximum, the 95th percentile and the 98th percentile of the summarized BitsPerSecond interface metrics for each group. The report should run for the previous month on the as-polled data.

 

Example

(formatted in Excel)

 

Approach

  • OpenAPI query to calculate group aggregate sum of BitsPerSecondIn and BitsPerSecondOut
  • Perl script to calculate the max, pct95 and pct98 values

 

Prerequisites

  • CA PM 3.1 and above
  • Perl 5.x (as provided with RHEL 6.x, no additional module required)
  • Script host with Perl and access to CA PM Data Aggregator port 8581
  • Relevant groups have interface items as direct members (not indirectly through devices)
  • The report should be run during first two weeks of a month to ensure full coverage of as-polled data for the previous month (with standard retention definition of 45 days)

 

Please see GroupPercentiles.pdf for more information.

 

Your feedback is appreciated so please post any comments in this thread.  As with all free Infrastructure Management Field Developed Utility postings, inquiries should be made through questions or comments in this thread, and the author, Lutz_Holzbecher, will provide a response.

All information downloaded or accessed (including field packs, customized solutions, patches etc.) are provided AS IS and no warranties are provided or made.  For more information you may click here.

1 person found this helpful

Outcomes