On Tue Mar 25 07:19:02 2003, Martin Edenhofer wrote:
Hi,
On Mon, Mar 24, 2003 at 02:23:01PM -0500, Charles R. Rusty Thompson wrote:
In time I could do this myself but I was wondering if anyone had written a
cleanup script for the OTRS database.
After the mail, users, etc are set up we have a testing cycle. After that
testing it would be nice to be able to clear all the cases from the system,
leaving the core user and setup data intact. If anyone has a scrub script or
could give some guidelines on what can/should be deleted by force it would
be great.
delete from article;
delete from article_attachment;
delete from article_plain;
delete from ticket_history;
delete from ticket;
Removes all existing ticket.
CT
Martin
You should "delete from time_accounting;" as well. Not having done this caused some "ghost-tickets" which broke up the correct accounting of time. I'll take a look at the other tables later today, to see if there are more "ghost-tickets" left. 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/
Hi Marina, 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.
Thanks for the info. I also created an FAQ article now: http://demo.otrs.org/otrs/faq.pl?ID=6 (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 Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
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/
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!
participants (3)
-
Daniel Balan -
Henn, Marina -
Martin Edenhofer