Nagios DB tables (nagios_servicechecks & nagios_hostchecks)

[davide.galletti.75]

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

[tgriep]

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.

[davide.galletti.75]

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

Cheers

[tgriep]

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