<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Ive been trying to get an answear to this, but
realised that the most simple thing is to drop the DB, and</FONT></DIV>
<DIV><FONT face=Arial size=2>then copy the userdatabase...to the new one and
recrate the queues. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>They told me that there is scripts to do this to
but then you can take 1 ticket at each time.</FONT></DIV>
<DIV><FONT face=Arial size=2>Also there is something that is called RTx:Shredder
that you can build your own script around.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>//Jonas</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=sivan.deray@net-aptitude.fr
href="mailto:sivan.deray@net-aptitude.fr">Sivan DERAY</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=rt-users@lists.bestpractical.com
href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2004 11:18
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [rt-users] Delete all
tickets</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=699075008-28072004>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=699075008-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=699075008-28072004>I'd like to know
if it's possible to get all the ticket generated erased without usings SQL
command on the database,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=699075008-28072004>so to get for the
next ticket creation the number #1.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=699075008-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=699075008-28072004>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=699075008-28072004></SPAN></FONT> </DIV>
<P>
<HR>
<P></P>_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Be
sure to check out the RT wiki at <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A></BLOCKQUOTE></BODY></HTML>