Page 1 of 1

Nagios database extraction

Posted: Fri Apr 05, 2013 3:49 pm
by ahackbartt
Hi!

I need to extract the information of CPU and memory usage from 48 servers that are already working with NAGIOS, i need the information 4 times a day and in the range of a month.

My question is if there is any possibility to get the information directly from the database and get it in an Excel Spreadsheet. If anyone has something simmilar created that will do it too.

Thanks in advance!!

Bye

Re: Nagios database extraction

Posted: Fri Apr 05, 2013 4:14 pm
by abrist
Are you after the performance data or the state?

Re: Nagios database extraction

Posted: Mon Apr 08, 2013 10:34 am
by ahackbartt
Hi abrist!

i´m dealing with performance data.

Thanks !

Re: Nagios database extraction

Posted: Mon Apr 08, 2013 2:05 pm
by abrist
The performance data is located in round-robin database files (rrds). You can dump their contents to a file with rrdtool. You should find your rrds at /usr/local/nagios/share/perfdata/

Code: Select all

rrdtool dump /path/to/rrd > /tmp/rrd_dump
less /tmp/rrd_dump