...

A report was required for billing when the usage exceeded the contract, sometimes referred to as 95th percentile billing, this report will be sent to another department for use in their reporting.  This report needed to have specific columns and headings for use in that departments department's systems.  A new more general report was created in opReports and this report needs to be transformed and copied transferred using SFTP.

Solution

Overview

A Two new report was reports were added to opReports 4.4.1 for Burst Billing Report or Bandwidth Exceeds Contract Report, currently when opReports generates this reportthese reports, it will look for the existence of a script called /usr/local/omk/bin/opreports-sftp.pl, if it finds this script file it will execute that report script file to operate on the reports generated by opReports, transform them and then transfer the files as required.

...