Page 1 of 1
Historical Information
Posted: Thu Oct 06, 2011 1:28 pm
by lacd00
Hi, We need to know how many days Nagios, could store informatión about indicators like performance, net, events, etc. and if is it possible keep that informatión into flat files?. This in order to make graphical reports from those files.
Re: Historical Information
Posted: Fri Oct 07, 2011 9:40 am
by lmiltchev
Log in information is kept in the database. You can check/change this setting by going to Admin->System Config->Performance Settings->Databases. The rrd data is stored for 2-4 years. What format files do you need? One of our developers wrote a script that you might find useful. It is called "rrd2csv.php". Basic usage and options info can be obtained by running in terminal:
Code: Select all
# /usr/local/nagiosxi/tools/rrd2csv.php -h
Re: Historical Information
Posted: Fri Oct 07, 2011 1:16 pm
by lacd00
Actually we just need to know the format and time, this is because our customer need create and modify reports and we are thinking use crystal reports to take the information for files or databases, concentrate all data y create the reports.
Which database you use?...this idea make sense to you?
Re: Historical Information
Posted: Mon Oct 10, 2011 10:34 am
by lmiltchev
Most of the data that you need will be in the mysql nagios database. You should not have any issues with using crystal reports and create the reports that you need.
Re: Historical Information
Posted: Wed Oct 19, 2011 11:29 am
by cloberjewels
Can you confirm which setting is specific to the rrd data under Admin->System Config->Performance Settings->Databases? Is it the Max Log Entries Age? Looks like the default is set to 90 but I want to set that to 2 years.
Also, does the rrd data appears to be 5 minute averages. Overtime (say 1yr) does that reduce to 1 hour or 1 day averages? Can this be configured?
Re: Historical Information
Posted: Wed Oct 19, 2011 4:41 pm
by mguthrie
RRD settings aren't currently configured through the web interface, as it will most likely break things unless you have a pretty solid understanding of rrdtool. Here's the breakdown as to how it's preserving performance data:
Code: Select all
# PNP default RRA config
#
# you will get 400kb of data per datasource
#
# 2880 entries with 1 minute step = 48 hours
#
RRA:AVERAGE:0.5:1:2880
#
# 2880 entries with 5 minute step = 10 days
#
RRA:AVERAGE:0.5:5:2880
#
# 4320 entries with 30 minute step = 90 days
#
RRA:AVERAGE:0.5:30:4320
#
# 5840 entries with 360 minute step = 4 years
#
RRA:AVERAGE:0.5:360:5840
These settings are located at /usr/local/nagios/etc/pnp/rra.cfg. I don't recommend changing these settings unless you know what you're doing ; )