Hi Daniel, On Mon, Feb 09, 2004 at 05:32:53PM +0200, Daniel Balan wrote: > Is there a script to delete all tickets older than yyyy/mm/dd. > For example: we are using OTRS starting with May 2003 (articles > stored in the file system) and the file size is > 8 GB. > > It will be useful to delete all tickets older than, let's say, 3 months.
In this case use the new GenericAgent: http://doc.otrs.org/cvs/en/html/generic-agent-example.html [...] # tickets older the 60 minutes TicketCreateTimeOlderMinutes => 60, # tickets newer then 60 minutes TicketCreateTimeNewerMinutes => 60, # tickets with create time older then .... TicketCreateTimeOlderDate => '2004-01-19 00:00:01', # tickets with create time newer then ... TicketCreateTimeNewerDate => '2004-01-09 23:59:59', [...] And set the delete option "Delete => 1," in the "New" section. PS: See also http://doc.otrs.org/cvs/en/html/performance-tuning.html for big installations. :) PPS: Backups are always recommended before you do delete actions! :) > Daniel Martin -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting f�r Ihr OTRS System? => http://www.otrs.de/
