DX NetOps Manager

Group Percentiles Report 

09-12-2017 03:10 AM

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.



(formatted in Excel)



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



  • 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.

0 Favorited
2 Files
pdf file
GroupPercentiles.pdf   331 KB   1 version
Uploaded - 05-29-2019
zip file
GroupPercentilesReport.zip   2 KB   1 version
Uploaded - 05-29-2019

Tags and Keywords

Related Entries and Links

No Related Resource entered.