[otrs] Delete some tickets

[Personal Técnico]

Hi,

I'm running OTRS 5. For testing purposes, I created some tickets that,
now, I would like to delete. How can I remove them? Directly from database?

Thanks.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[Smulsky, David]

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/comment-page-1/

Dave

[Sujeeva Tissaarachchi]

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: Personal Técnico <tecn...@caos.uab.es>
To: ot...@lists.otrs.org
Sent: Thursday, 22 September 2016, 18:21
Subject: [otrs] Delete some tickets

[Renee B]

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 not delete the links between tickets etc.)

Kind regards,
Renée

Am 23.09.2016 um 08:54 schrieb Sujeeva Tissaarachchi:

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: Personal Técnico <tecn...@caos.uab.es>

 To: ot...@lists.otrs.org 
 Sent: Thursday, 22 September 2016, 18:21
 Subject: [otrs] Delete some tickets
   
Hi,

I'm running OTRS 5. For testing purposes, I created some tickets that, 
now, I would like to delete. How can I remove them? Directly from database?

Thanks.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs


   

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-- 
Perl / OTRS development: http://perl-services.de
OTRS AddOn repository: http://opar.perl-services.de