Page 1 of 1
Nagios Query in a Table Format
Posted: Tue Sep 06, 2016 3:09 pm
by Berto
Hello,
I was approached by one of the departments DBAs and they were wondering if the data that Nagios queries can be put into a table format for them to see. Not sure if this can be done but figured I would ask.
--Berto
Re: Nagios Query in a Table Format
Posted: Tue Sep 06, 2016 3:16 pm
by mcapra
Local default MySQL root user is:
What sort of data are they looking for? There's a few different places that Nagios might pull data from. The above only covers data stored in the MySQL databases.
Re: Nagios Query in a Table Format
Posted: Fri Sep 23, 2016 4:44 pm
by Berto
Sorry for a late reply. I believe they're wondering if the data they get from the check_postgres plugin can just be formatted into a table to see the results, instead of seeing it in a graph. Not sure if that makes it any clearer; they prefer seeing their data in a formatted table, then a graph.
Re: Nagios Query in a Table Format
Posted: Mon Sep 26, 2016 10:10 am
by mcapra
The performance data from returned from plugins (such as check_postgres) is stored in RRD files located at /usr/local/nagios/share/perfdata/<host>/<service>.rrd
You should be able to use RRDTool to dump those .rrd files into XML and from there parse it into a tabular format.
You might also consider using the "Performance Data Tool" component created by
@Box293 which allows you to view the raw data in a tabular format:
https://exchange.nagios.org/directory/A ... ol/details
Re: Nagios Query in a Table Format
Posted: Thu Oct 13, 2016 3:14 pm
by Berto
Thank, this can be closed.
--Berto
Re: Nagios Query in a Table Format
Posted: Thu Oct 13, 2016 3:41 pm
by dwhitfield
Glad to hear it is resolved. I am going to lock the thread. Please feel free to post again if you have you another issue. Thank you for using the Nagios forums!