Re: Events

[Martin Pala]

Hello,

currently the M/Monit events can be deleted only manually - the next M/Monit release will allow to set automatic events aging and cleanup. The events in the current M/Monit version are deleted only when the host to which they belong is deleted.

The procedure for the manual events purging:

1.) stop M/Monit

2.) connect to the database and delete the events from the event table + update the event count cache … for example to delete all events older then July 1 2011 and update the cache:

DELETE FROM event WHERE collected sec <= 1309478400;

UPDATE host SET eventscount=(SELECT COUNT(*) FROM event WHERE event.hostid=host.id);

UPDATE service SET eventscount=(SELECT COUNT(*) FROM event WHERE event.hostid=service.hostid AND event.service_nameid=service.nameid);

3.) start M/Monit

Regards,

Martin

On Jun 30, 2012, at 4:12 PM, Conor C - Hudson Valley Host wrote:

Hello,

How do you delete server/system events from Mmonit?

--

Thanks for choosing Hudson Valley Host

Conor Calby
Senior Vice President
Email: address@hidden
Phone Number: 1-800-497-5377 Ext: 805

--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general