Nagios Support Forum

Hello,

We would like to use an internal tool to extract data from Nagios to generate availability reports form hosts and services.
I've been looking for a way to get this data, but I only found the last checks in the mysql database on nagios_hostchecks table.

Is there any way to check historic data? If it's not mantained, is there any plugin or extension that I could use to achive this?

Thanks a lot.

This is a currently feature of Nagios Xi our Commercial monitoring software. Feel free to take a look at the reporting system and see how you could adapt it to Nagios core. Otherwise you could take a look at this section of the Exchange website:

http://exchange.nagios.org/index.php?op ... y%20report

Or open a feature request for this item at:

http://tracker.nagios.org

Though this feature may not be added by us due to it's availability in Nagios Xi.

Hi,

I know there is a feature on NagiosXI, I'm using it already.
The problem I have right now is that we need to make some reports with cristal reports, and I have to provide data in a format Cristal Reports understands.
I've been looking at NDO database structure, but I can't get what I want from it. I need the performance data stored in the rrd perfdata files.
I've seen the availability.php script form nagiosXI, but again, I cant see a way to get the whole info, just a summary.

This is why I was asking if there is any plugin, or script to get the data from the performance rrd files to a clasic csv file that contains just the time and the AVERAGE from each of the service files.
I am working on a bash script using rrdtools, but I'm not a great programmer....

Ah, my mistake for some reason I thought you were running Core, this is not something that is currently implemented but sounds like a great feature for our next milestone or yearly release, you can submit a feature request to the Nagios XI tracker as opposed to the core tracker here:

http://tracker.nagios.com

Please provide a good deal of detail and our developers will take a look at it.

Maybe I am missing something but I see no way to create custom reports in Nagios XI there are a list of defined reports and no option to create my own... I need to be able to create a report poing to multiple groups of client systems, and not have to create a one of each kind of report for each group.


Thanks

Have you considered creating a hostgroup for those multiple groups, and then running a report on the new hostgroup?

Creating custom reports is not available in Nagios XI at this time. I would recommend posting a feature request, as suggested by slansing on our bug tracker:

http://tracker.nagios.com/

abrist wrote:Have you considered creating a hostgroup for those multiple groups, and then running a report on the new hostgroup?

Just did that ... having a problem creating a scheduled report and forcing it to use that new group... What does it use by default if you specify no group?

If you are looking for say, the availability report on a hostgroup. Go to the report tab, open availability reports, select the hostgroup that you wish to use and any other details, then press go. From there if you have enterprise you can schedule this report to generate at an interval that you like. You can also pull this data in pdf, csv, or email it.