Custom Reporting of XI Monitoring Data

[[email protected]]

(1) We are interested in creating custom reports. Does anyone have lessons learned from using reporting tools such as BIRT, JasperReports, Cognos, Crystal Reports and/or WebFocus against Nagios XI monitoring data? Lessons learned from other tools are welcome as well.
(2) Is there a reporting tool of choice to use with Nagios XI?
(3) With XI is all the monitoring data (i.e. service status, not configuration data) stored in relational databases?

Kind Regards,
Bill Martin

[Box293]

You are most likely going to need to write reports in PHP. Have a look at the existing reports in XI and you could take one of those to create a new one. They are all in /usr/local/nagiosxi/html/reports

(3) With XI is all the monitoring data (i.e. service status, not configuration data) stored in relational databases?

The data is stored in the nagios mysql database.
If you want the historic performance data, this is all in RRD files in:
/usr/local/nagios/share/perfdata