Page 1 of 1

How to export out the bandwidth performance and report data?

Posted: Wed Feb 11, 2015 1:56 am
by phyo
HI,
I want to know how long nagiosxi can keep the bandwidth performance graph data? I saw last year is maximum in the graph timeframe drop down list. That means can keep two years performance graph data. If nagios can only keep for two year, what will happen after two year? It will delete the old performance graph data automatically or need to delete manually?

Image

For Bandwidth report, it will display two years data. How many nagiosxi can keep bandwidth data for report? if it can only keep two years, what will happen after two years? Nagios will delete the bandwidth report data automatically or need to delete manually?

Image

Thanks.

Re: How to export out the bandwidth performance and report d

Posted: Wed Feb 11, 2015 10:25 am
by scottwilkerson
By default in XI you can get up to 4 years, to display longer/custom timeframes, you would need to click on the title of the graph (in service Detail Tab) and select the custom time period..

For more than 4 years, you would need to modify the /usr/local/nagios/etc/pnp/rra.cfg BEFORE collecting data to specifically create the RRD files with longer timeframes.

NOTE: Changing the timeframes will significantly change the amount of drive space used, RRD files are fixed size from creation and cannot be changed.

Re: How to export out the bandwidth performance and report d

Posted: Wed Feb 11, 2015 8:38 pm
by phyo
By default in XI you can get up to 4 years, to display longer/custom timeframes, you would need to click on the title of the graph (in service Detail Tab) and select the custom time period..
I don't get what you mention. Is it for performance graph or bandwidth usage report?
For more than 4 years, you would need to modify the /usr/local/nagios/etc/pnp/rra.cfg BEFORE collecting data to specifically create the RRD files with longer timeframes.
NOTE: Changing the timeframes will significantly change the amount of drive space used, RRD files are fixed size from creation and cannot be changed.
This option will effect for both performance graph and bandwidth usage report?

Thanks.

Re: How to export out the bandwidth performance and report d

Posted: Thu Feb 12, 2015 9:03 am
by scottwilkerson
the settings I previously mentioned were for the Performance graphs.

To change the settings for the RRD report, you would need to add values to your /etc/mrtg/mrtg.cfg
See http://oss.oetiker.ch/mrtg/doc/mrtg-reference.en.html
The items of interest are those starting with RRDRowCount

Re: How to export out the bandwidth performance and report d

Posted: Fri Feb 13, 2015 2:05 am
by phyo
scottwilkerson wrote:the settings I previously mentioned were for the Performance graphs.
To change the settings for the RRD report, you would need to add values to your /etc/mrtg/mrtg.cfg
See http://oss.oetiker.ch/mrtg/doc/mrtg-reference.en.html
The items of interest are those starting with RRDRowCount
How about to export performance graphs and bandwidth usage files? Which file we have to backup?
By default in XI you can get up to 4 years
Is this both performance graph and bandwidth usage report? What will happen after 4 years? Old data will delete automatically or must delete manually?

Thanks.

Re: How to export out the bandwidth performance and report d

Posted: Fri Feb 13, 2015 10:45 am
by abrist
phyo wrote:How about to export performance graphs and bandwidth usage files? Which file we have to backup?
Depends how you want to export it. You can schedule a report of the bandwidth report page which will send a pdf of the report.
You can also dump the rrd to xml by running rrdtool dump against the rrd and redirecting it to a file. for example:

Code: Select all

rddrtool dump /usr/local/nagios/share/perfdata/<host>/<service>.rrd > /tmp/rrd.xml
phyo wrote: Is this both performance graph and bandwidth usage report? What will happen after 4 years? Old data will delete automatically or must delete manually?
Yes, it applies to all nagios (ncpd/process_perfdata.pl) created rrds. In 4 years the oldest data (that which is older than 4 years) will be lost. The change is constant, so at a maximum, you will only ever have 4 years difference between the newest and oldest data.

Re: How to export out the bandwidth performance and report d

Posted: Tue Feb 17, 2015 1:40 am
by phyo
rddrtool dump /usr/local/nagios/share/perfdata/<host>/<service>.rrd > /tmp/rrd.xml
This should be

Code: Select all

rrdtool dump /usr/local/nagios/share/perfdata/<host>/<service>.rrd > /tmp/rrd.xml
. Right?

After export out the data, how to import back this data to other machine?

By default, it will store 4 years data. Right?

Re: How to export out the bandwidth performance and report d

Posted: Tue Feb 17, 2015 9:18 am
by scottwilkerson
If the machines are the same architechure (e.g. both 64 bit) you can just copy the file... Our backups in Nagios XI already contain all the RRD files