Reports - Performance Info

[andyb4u]

Hi,

I have been asked to gather more info on how the reporting works in XI with a view to improving the length of time it takes to run some reports.

Do the reports gather the data solely from MariaDB or are the logs found in /usr/local/nagios/var/archives used as well?

I can see in the product roadmap for Nagios XI 6.0 Q1 2020 :
New report management system and backend report generation (running reports in the background) including saving reports
Does "running in the background" mean that reports will run quicker or could be offloaded to another server? Does saving reports mean the ability to save a reports (scheduled) output to the local filesystem or a remote system? Can I get confirmation that this cannot be currently done.

For information we are running XI 5.4.13 (not latest version as we can't upgrade without downgrading core to work with gearman, our security team won't allow it), Offloaded MariaDB, Gearman with 3 worker servers. 1262 hosts and 11755 services. Users

Any info would be much appreciated.

Regards,
Andy

[benjaminsmith]

Hi Andy,

Do the reports gather the data solely from MariaDB or are the logs found in /usr/local/nagios/var/archives used as well?

The short answer is both. Most of the reports are generated using the history stored in the nagios database. You can adjust the amount of time this database will keep its history in the performance settings from the admin panel. The availability report uses text based logs.

Does "running in the background" mean that reports will run quicker or could be offloaded to another server? Does saving reports mean the ability to save a reports (scheduled) output to the local filesystem or a remote system?

Nagios XI 6 will have a report manager for handling running reports and managing completed reports. For example, you'll be able to start a report and it will run in the background allowing the admin to use other parts of the interface. Those reports will be stored on the local file system and can be downloaded or emailed when complete.

Let me know if you have any other questions.

[andyb4u]

Thanks for the info. I have some follow up questions:

Is it only the the availability report that uses the text based logs?

Is there any guidance around how long to keep these text logs in /usr/local/nagios/var/archives? I have inherited a system which has nearly 5 yrs worth of logs in this folder (3GB in size).

Would there be any functionality to allow saving the report output to a Windows file share? If the output is only to be saved locally how will the user download it - a manual process or could it be scheduled/scripted?

[benjaminsmith]

Hi Andy,

Is it only the the availability report that uses the text based logs?

The availability, executive Summary and sLA report parse the logs files, and state history, notification and event log will query the database.

Is there any guidance around how long to keep these text logs in /usr/local/nagios/var/archives?

The length of time to keep the reports is at your discretion for reporting and auditing purposes.

As far as the new reporting functionality in Nagios XI 6, I don't have a definitive list of feature details. Please check the roadmap page for more updates as we get closer to the release targets.

Let me know if you have any other questions.

Nagios XI Roadmap
https://www.nagios.com/roadmaps/