Script to generate Trend,TrendAgg,TopN,Health and Stats Summary reports csv

Document created by norja10 Employee on Mar 23, 2015
Version 1Show Document
  • View in full screen mode

Usage:

 

usage: perl generate_csv_data.pl  -D [PrevMonth|Prev7] -R [5min|1hr|1day] -T [TopN|BusHrTopN|Trend|BusHrTrend|TrendAgg|BusHrTrendAgg|StatsSummary|BusHrStatsSummary|Health|BusHrHealth]

                     -G <CAPC Group ID> -M <Metic List> -F <Metric Family Name> -H <CAPC Hostname|IP>

                     -u <CAPC Username> -p <CAPC user password> -f <Path to output CSV file name>

where:

        -D  Date Range - The range data will be processed. Valid values: PrevMonth, Prev7

        -R  Data Resolution - the resolution of data returned. Valid values: 5min, hr, day

        -T  Report Type. Valid values: TopN, Trend, TrendAgg, StatsSummary, Health

        -G  Group Name - The CAPC Group Name that the report will be run against (case insensitive).

        -M  Metric(s) you want to report on. A comma seperated list can be provided. List of valid metrics are shown bel

ow.

        -B  Business Hour Name

        -F  Metric Family metrics are associated with. Valid values are Interface or QoS.

        -H  CAPC hostname or ip address.

        -u  CAPC username.

        -p  CAPC password.

        -f  Path and name of CSV file that needs to be generated.

        -h  help - this help screen

 

 

 

 

List of valid metrics

---------------------

 

 

        i. Interface:

 

 

                .UtilizationIn.Max       .UtilizationOut.Max

                .UtilizationIn.Avg       .UtilizationOut.Avg

                .Utilization.Avg

 

 

                .HistoricalInterfaceSpeed.Avg

 

 

                .Bits.Sum        .BitsIn.Sum     .BitsOut.Sum

                .BitsIn.AvgRate          .BitsOut.AvgRate

 

 

                .Bytes.Sum       .BytesIn.Sum    .BytesOut.Sum

                .BytesIn.AvgRate         .BytesOut.AvgRate

1 person found this helpful

Outcomes