Hello! We have testet OTRS extensive - with a lot of garbage in the database. Could anybody tell me, how to erase all tickets, so there is no history in it? The settings should be there, because all is finetuned! Thank you for your help Gerhard Forster
Hi Gerhard, On Mon, Jun 23, list@supratec.de wrote:
We have testet OTRS extensive - with a lot of garbage in the database.
Could anybody tell me, how to erase all tickets, so there is no history in it?
One of the very basic ideas of a ticket system is that there is no way to physicly delete a ticket. Does that answer your question? take care Stefan -- Stefan Wintermeyer While I might trust the doctor to remove a splinter or lance a boil, I cannot trust him to replace a brain. (Spock) "Star Trek"
--- Stefan Wintermeyer
One of the very basic ideas of a ticket system is that there is no way to physicly delete a ticket.
What about moving the ticket(s) to the "delete" queue?
I assumed that deleted the ticket from the database.
Cheers,
Alan Murrell
On Mon, Jun 23, 2003 at 11:43:42AM -0400, Alan Murrell wrote:
[...] What about moving the ticket(s) to the "delete" queue? I assumed that deleted the ticket from the database.
Jepp. Or if you have a lot of test-ticket, do it like this: http://www.mail-archive.com/otrs@otrs.org/msg01122.html [...] delete from article; delete from article_attachment; delete from article_plain; delete from ticket_history; delete from ticket; Removes all existing ticket. [...]
Alan Murrell
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
participants (4)
-
Alan Murrell -
list＠supratec.de -
Martin Edenhofer -
Stefan Wintermeyer