Custom reports

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Viyullas33
Posts: 6
Joined: Fri Jan 20, 2012 3:54 am

Custom reports

Post by Viyullas33 »

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.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Custom reports

Post by slansing »

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.
Viyullas33
Posts: 6
Joined: Fri Jan 20, 2012 3:54 am

Re: Custom reports

Post by Viyullas33 »

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....
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Custom reports

Post by slansing »

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.
lavinl
Posts: 2
Joined: Tue Sep 10, 2013 12:06 pm

Re: Custom reports

Post by lavinl »

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
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Custom reports

Post by abrist »

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.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Custom reports

Post by lmiltchev »

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/
Be sure to check out our Knowledgebase for helpful articles and solutions!
lavinl
Posts: 2
Joined: Tue Sep 10, 2013 12:06 pm

Re: Custom reports

Post by lavinl »

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

Post by sreinhardt »

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