Historical Information

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

[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

[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?

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

[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?

[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 ; )