Page 1 of 1

Cleaning up the database

Posted: Tue Oct 23, 2012 6:09 pm
by tribbink
Hi All,

I want to clear up all my historical data in the NagiosXI 2012R1.0 database, except Hosts, Services, Hostgroups an Servicegroups etc.
Is there a way to delete them, so i start witch all my hosts and services, and start over collecting data.

Best Regards,
Ton

Re: Cleaning up the database

Posted: Tue Oct 23, 2012 7:39 pm
by scottwilkerson
Which type of historical data?

THESE ARE NOT REVERSIBLE

Delete Performance data

Code: Select all

rm -rf /usr/local/nagios/share/perfdata/*
Other historical data can be remove by lowering the times in Admin -> Performance Settings -> Database tab

Finally, historical availabity and logs can be removed by

Code: Select all

rm -f  /usr/local/nagios/var/archives/*

Re: Cleaning up the database

Posted: Sat Oct 27, 2012 12:53 pm
by tribbink
Thanks, i cleared the data. But it not filling with new performance data anymore.