Nagios Query in a Table Format

[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

[mcapra]

Local default MySQL root user is:

Code: Select all

user: root
pass: nagiosxi

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.

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

[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

[Berto]

Thank, this can be closed.

--Berto

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