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!