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. CT
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 -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson
participants (2)
-
Charles R. "Rusty" Thompson -
Martin Edenhofer