Pavel,

On Nov 9, 2006, at 3:32 AM, Chlupáček Pavel wrote:

Question



1. Is there a way how to alter (per device) maximum # of days to keep history messages for device?
Yes this is just a question of running the proper SQL delete statement. This will keep events for 3 months for a device.

DELETE h,j,d FROM history h
   LEFT JOIN log j ON h.evid = j.evid
   LEFT JOIN detail d ON h.evid = d.evid
WHERE DATE_ADD(StateChange, INTERVAL 3 MONTH) < NOW() and device='YOURDEVICE';


2.       What is the default?
Hum looks like I took this out of the default setup which was the following (three months):

DELETE h,j,d FROM history h
   LEFT JOIN log j ON h.evid = j.evid
   LEFT JOIN detail d ON h.evid = d.evid
       WHERE DATE_ADD(StateChange, INTERVAL 3 MONTH) < NOW();

3. Can I somehow say to certain device to log all incoming events irrelevant of their type, and still have normal rules applying to them?

Not sure I understand but today device specific event rules aren't the greatest.

-EAD_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users

Reply via email to