XI reporting not working properly

[anil_kumarv]

When I go to reports and select "Top Alert producers", nothing comes up. Even if I select any hostgroup, timeperiod nothing happens with 0 record.
Even if I select any host or service and select "View Host History" and"View host/service notification", nothing comes up with 0 record, though the host or service has been down for sometime.

I'm guessing XI reports are not working properly. Is it something to do with the options you set in "NDOUtils Database" under "Performance Settings". Currently we have Max Log Entries Age, Max Notifications Age, Max State History Age all three set to 0.

-- Anil Kumar V

[sreinhardt]

Let's start with, what version of XI are you presently running? I am not seeing this on either my 2012 or 2014 machines, so it is possible that the DB changes could cause this.

[anil_kumarv]

Current version : Nagios XI 2012R2.9. We are planning to upgrade to 2014R1.0 in sometime. Also all our hosts/service configs are static files(though I don't think it should affect reporting).

[lmiltchev]

Start a running tail on the apache error log:

Code: Select all

tail -f /var/log/httpd/error_log

try to access the "Top Alert Producers" report, then go back to the CLI, copy and post the output of the tail.

[anil_kumarv]

Output of the error_log, no matter if i select for today,yesterday or last week for "Top Alert Producers" there is nothing in the logs :
---------------------------------------------------------------------------
# tail -f /var/log/httpd/error_log
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Counting pages (2/6) aring
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Done
Done
---------------------------------------------------------------------------

[slansing]

You should definitely have those max age entries set to something above 0, currently, it sounds like you are not keeping any logs that would be used by your reports. Bump them up to 1 day and let it gather some data for an hour or so, then try to run the report, see if this has an effect.

[anil_kumarv]

Okay after bumping the Max Log Entries Age, Max Notifications Age, Max State History Age to 1 for all the three, we are seeing the Top Alert Producers and other options for host/services.
What are the recommended values for those three options. In one of the your manual's (http://assets.nagios.com/downloads/nagi ... zation.pdf) you have suggested 90, 90 & 730 respectively.

Will increasing the values to recommended values effect the performance of XI GUI? The reason I'm asking is sometimes when we select Hostgroup Overview or Summary, It does take some time to load all of them(we have 366 hostgroups).

[scottwilkerson]

these are the number of days you want to keep in the database which will be required to create reports. The performance should not be affected with the suggested quantities, especially on the Hostgroup Overview or Summary however it will increase. The biggest tradeoff will be a larger DB size.

[anil_kumarv]

If I try to filter the Top Alert producers for a specific hostgroup, it says zero records. But I can see few hosts part of that specific hostgroup in Top Alert producers without any filtration.

Any reason why it is doing so..?

[lmiltchev]

Do you get a different output when you change the time period? Other words, are the times of the latest alerts for these hosts within the time period that you selected from the drop-down menu? Can you show us a couple of screenshots (not-filtered, and filtered by a hostgroup)?