Nagios database extraction

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
ahackbartt
Posts: 2
Joined: Fri Apr 05, 2013 3:39 pm

Nagios database extraction

Post 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
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Nagios database extraction

Post by abrist »

Are you after the performance data or the state?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
ahackbartt
Posts: 2
Joined: Fri Apr 05, 2013 3:39 pm

Re: Nagios database extraction

Post by ahackbartt »

Hi abrist!

i´m dealing with performance data.

Thanks !
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Nagios database extraction

Post 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
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked