Hi,
please do not change values (update, delete, ...) in the database!
Please use the scripts shipped with OTRS or the GenericAgent.
Using OTRS scripts or the GenericAgent handles everthing: Update/delete
the cache, delete information that belong to the ticket.
(eg the SQL statements below do
Hi,
You need to connect to your database (default MySQL) and issue a delete command
DELETE FROM ticket
DELETE FROM ticket_history
DELETE FROM article
DELETE FROM article_plain
Above deletes all tickets in the system. Otherwise use the where clause
Best Regards,
Sujeeva Tissaarachchi
From:
Make a new queue (or use the Junk queue that comes out of the box), then create
a Generic Agent to select and Delete all of the tickets in that queue either as
a scheduled event or one-time run.
Details:
http://blog.otrs.org/2011/08/04/otrs-tips-tricks-create-a-junk-queue-that-deletes-tickets/c