The availability report is very slow, it takes up to 2 hours to get a report for a month on a specific hostgroup. I allready tried to move the archive data to a ramdisk, and report from there, but this doesn't increase the performance over the ssd's, where the data stands.
The legacy report however report is much, much faster, on the same data it takes less then 30 seconds.
Is it possible to send availability data to a datawarehouse so we can create more advanced reports?
We are running Nagios XI 5.6.14, the upgrade to 5.7.2 doesn't work for our environment, see other posts.
Our Nagios environment contains ~3800 hosts and ~50000 services.
kind regards,
Joris Weijters
send availability data to datawarehouse
Re: send availability data to datawarehouse
I'd be interested in this too.
Currently, I have 12 monthly emails that get sent to me with the uptime % for a set of selected services, enter those manually into a google doc, and then plot that in a graph.
I've had a look in the production DB to see if i can get the data directly, but it only has the time a service went down and when it came back up, not the duration.The data must be in Nagios somewhere as its possible to run, very very very slow reports to get that information through the UI, so the question is, where is it kept?
Currently, I have 12 monthly emails that get sent to me with the uptime % for a set of selected services, enter those manually into a google doc, and then plot that in a graph.
I've had a look in the production DB to see if i can get the data directly, but it only has the time a service went down and when it came back up, not the duration.The data must be in Nagios somewhere as its possible to run, very very very slow reports to get that information through the UI, so the question is, where is it kept?
You do not have the required permissions to view the files attached to this post.
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: send availability data to datawarehouse
Hi,
The Availability report is very I/O intensive, so if you pulling a large data set, it can take some time. While do not have a built-in feature to send this to another application, you can download or even schedule the report as a CSV file.
You can also access some data from the API, go to Help > API Docs > Objects Reference > Data Exporting for details.
https://www.nagios.com/roadmaps/
The Availability report is very I/O intensive, so if you pulling a large data set, it can take some time. While do not have a built-in feature to send this to another application, you can download or even schedule the report as a CSV file.
You can also access some data from the API, go to Help > API Docs > Objects Reference > Data Exporting for details.
We do recognize the need for more flexibility in reporting, and will be adding more functionality in version 6, see:GET objects/hostavailability
This endpoint returns host availability information for a speficied, host, hostgroup, or servicegroup. While there are no required paramteres, you must have at least one host, service, hostgroup, or servicegroup in your query.
https://www.nagios.com/roadmaps/
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!