Nagios Support Forum

How long will the data be kept in the historical tables? Is there any way to configure it? It looks to me that by defautl they are purged quite frequently.

Thanks for your answer! In our case, we need to query the historical tables anyway since we want to retrieve all the status from a previous timestamp until the cureent time. If the result of querying the historical tables already includes the current status, we do not need to do a second query into ...

In the Nagios database, the historical data is stored in nagios_servicechecks and nagios_hostchecks tables and the current status is store in nagios_hoststatus and nagios_servicestatus tables. It looks to me that the current status is inserted into the current status tables and the historical tables...