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/ _______________________________________________ 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/
