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/