centreon reporting rrd
The script report_rrd.pl generates a specific ascii report about a host group + specific service (and metric) during a specified time range.
The output report shows the average value (or percentile) and is based from data of the RRD files generated by Centreon (the script must be running on the machine hosting the RRD files).
- INPUT : text file with hostnames or name of the hostgroup + name of the focus service + (start & end date)
- OUTPUT : ascii report with average value
Requirements
- Perl
- mysql client
- rrdtool
Tested with
- Centreon 2.5.4
- perl 5.10.1
- rrdtool 1.4.7
Options
option --hostfile or --hostgroup, and --service are compulsory, others are optional.
option --timerange allows to calculate average values during several hours, for example during Working Hours.
If no options --start or --end, the last mounth is used as the default time range.
./reporting_rrd.pl --hostgroup <host_group_name> (if option --hostfile not used)
--hostfile <myhosts.txt> (text file with one hostname by line)
--service <name_of_the_service>
[--metric <name_of_the_metric>]
[--start <DD-MM-YYYY>]
[--end <DD-MM-YYYY>]
[--timerange <regex with date format> (date format: Fri Nov 28 14:15:33 2014)]
[--sort ascending|descending]
[--top N]
[--csv <chr>] (for csv output)
[--percentile XX]Performance
For 231 devices + one selected service + one metric + time range of one month:
real 0m9.179s
user 0m1.099s
sys 0m1.183s
For 1000 devices + one selected service + one metric + time range of one month:
real 1m8.093s
==> 6 or 7 secondes since the version 23
user 0m7.454s
sys 0m10.865s
Examples
reporting_rrd.pl --hostfile myhosts.txt --service CPU
--start 01-11-2014 --end 01-12-2014 --sort descending
myhosts.txt service:CPU from:01-11-2014 to 01-12-2014
+-----------------------+------------+---------------+-----------------+
| hostname | service | metric | value (%) |
+-----------------------+------------+---------------+-----------------+
| TOTO_host1 | CPU | load_5_min | 6.29 |
| TOTO_host1 | CPU | load_1_min | 6.14 |
| TOTO_host1 | CPU | load_5_sec | 6.09 |
| TOTO_host2 | CPU | load_1_min | 5.97 |
| TOTO_host2 | CPU | load_5_min | 5.97 |
| TOTO_host2 | CPU | load_5_sec | 5.82 |
| TOTO_host3 | CPU | load_1_min | 4.01 |
| TOTO_host3 | CPU | load_5_min | 4.01 |
| TOTO_host3 | CPU | load_5_sec | 4.00 |
| TOTO_host4 | CPU | load_5_min | 3.01 |
| TOTO_host4 | CPU | load_1_min | 3.01 |
| TOTO_host4 | CPU | load_5_sec | 3.01 |
+-----------------------+------------+---------------+-----------------+reporting_rrd.pl --hostfile myhosts.txt --service CPU --metric load_5_min
--start 01-11-2014 --end 01-12-2014 --sort descending
myhosts.txt service:CPU from:01-11-2014 to 01-12-2014
+-----------------------+------------+---------------+-----------------+
| hostname | service | metric | value (%) |
+-----------------------+------------+---------------+-----------------+
| TOTO_host1 | CPU | load_5_min | 6.29 |
| TOTO_host2 | CPU | load_5_min | 5.97 |
| TOTO_host3 | CPU | load_5_min | 4.01 |
| TOTO_host4 | CPU | load_5_min | 3.01 |
+-----------------------+------------+---------------+-----------------+reporting_rrd.pl --hostfile myhostnames.txt --service Traffic% --metric traffic_out
--start 01-11-2014 --end 10-11-2014 --sort descending --percentile 95
myhostnames.txt service:Traffic% From:01-11-2014 to 10-11-2014
+----------+-----------------------------------+-------------+----------------+
| hostname | service | metric | value (Bits/s) |
+----------+-----------------------------------+-------------+----------------+
| HOST1 | Traffic Gi0/0/0 - Tronc COMMUN | traffic_out | 201363140.88 |
| HOST1 | Traffic Te0/1/0 - vers HOST2 eth3 | traffic_out | 29108307.05 |
| HOST1 | Traffic Te0/1/0.17 - vers HOST3 | traffic_out | 24642008.87 |
| HOST1 | Traffic Gi0/0/1 - Tronc ADSL | traffic_out | 7147156.44 |
| HOST1 | Traffic Te0/1/0.10 - vers HOST4 | traffic_out | 5215652.37 |
| HOST1 | Traffic Te0/1/0.9 - vers HOST5 | traffic_out | 1490047.99 |
| HOST1 | Traffic Gi0/0/5 - vers TRONC FT56 | traffic_out | 1457569.49 |
+----------+-----------------------------------+-------------+----------------+Example with --timerange (target : only the working hours) :
reporting_rrd.pl --hostfile TOTO.txt --service "Traffic Te0/3/0 - vers WORLD"
--start 01-11-2014 --end 01-12-2014
--timerange "^(Mon|Tue|Wed|Thu|Fri) ... .. (08|09|10|11|12|13|14|15|16|17|18):..:.. 2014$"
TOTO.txt service:Traffic Te0/3/0 - vers WORLD From:01-11-2014 to 01-12-2014
+-----------------+------------------------------+-------------+----------------+
| hostname | service | metric | value (Bits/s) |
+-----------------+------------------------------+-------------+----------------+
| TOTO1 | Traffic Te0/3/0 - vers WORLD | traffic_in | 106005763.81 |
| TOTO2 | Traffic Te0/3/0 - vers WORLD | traffic_in | 38992621.03 |
| TOTO1 | Traffic Te0/3/0 - vers WORLD | traffic_out | 28826598.06 |
| TOTO2 | Traffic Te0/3/0 - vers WORLD | traffic_out | 85628434.92 |
+-----------------+------------------------------+-------------+----------------+