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.
Custom reports
-
slansing
- Posts: 7698
- Joined: Mon Apr 23, 2012 4:28 pm
- Location: Travelling through time and space...
Re: Custom reports
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.
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.
-
Viyullas33
- Posts: 6
- Joined: Fri Jan 20, 2012 3:54 am
Re: Custom reports
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....
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....
-
slansing
- Posts: 7698
- Joined: Mon Apr 23, 2012 4:28 pm
- Location: Travelling through time and space...
Re: Custom reports
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.
http://tracker.nagios.com
Please provide a good deal of detail and our developers will take a look at it.
Re: Custom reports
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
Thanks
Re: Custom reports
Have you considered creating a hostgroup for those multiple groups, and then running a report on the new hostgroup?
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.
"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.
Re: Custom reports
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/
http://tracker.nagios.com/
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Custom reports
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?
-
sreinhardt
- -fno-stack-protector
- Posts: 4366
- Joined: Mon Nov 19, 2012 12:10 pm
Re: Custom reports
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.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.