
Hello Martin, 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. Regards, Daniel Monday, February 9, 2004, 5:21:08 PM, you wrote: Martin> Hi Marina, Martin> On Mon, Feb 09, 2004 at 11:37:43AM +0100, Henn, Marina wrote:
delete from article; delete from article_attachment; delete from article_plain; delete from ticket_history; delete from ticket;
Removes all existing ticket. [...] You should "delete from time_accounting;" as well.
Martin> Thanks for the info. Martin> I also created an FAQ article now: Martin> http://demo.otrs.org/otrs/faq.pl?ID=6 Martin> (this will be our faq-database in future).
Marina
__________
Netzlink Informationstechnik GmbH Heinrich-Büssing-Ring 41 D-38102 Braunschweig Telefon: 0531-7073430 Telefax: 0531-7073459 http://www.netzlink.com http://www.netzlink.com/
Martin> Martin Edenhofer Martin> -- Martin> ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg Martin> http://www.otrs.de/ :: Manage your communication! Martin> _______________________________________________ Martin> OTRS mailing list: otrs - Webpage: http://otrs.org/ Martin> Archive: http://lists.otrs.org/pipermail/otrs Martin> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Martin> Support oder Consulting für Ihr OTRS System? =>> http://www.otrs.de/