Nagios Support Forum

Hi,
i was looking for some historical data and checking the tables on the DB and found that nagios_servicechecks and nagios_hostchecks are empty, i read in an other post that in Nagios XI these tables aren't populated, is that correct ? (and no way of activating it).

if so, is there any other table that contains, even if less data, some historical data ?

the nagios_hoststatus and nagios_servicestatus only contain the data of the last check, so aren't of any use for what i need.

thanks

That is correct, Nagios XI does not use those 2 tables to function.

The nagios_logentries tables stores the output of the Host and Service checks, you could use that table and parse the output for what you want.
The nagios_statehistory table would be another one to use. It is used for the State History report in the XI GUI. That one usually has the most amount of data.

Thanks,
I'll give it a look and try.

Cheers

Your welcome. Let us know if you have any further questions.