[rt-users] Purge Tickets

[Andreas Wahlfeldt]

hi mattew,

what you are going to do is EXTREMLY dangerous to the integrety of your
rt-db and as far as i know not supported in any way.
the recomended way to do this, would probably be to upgrade to rt3 and then
use rtx-shredder (http://search.cpan.org/~ruz/RTx-Shredder).

if you want/have to stay with rt2, there is a script that is supposed to do
what you need. 

notice: 
I'VE NEVER USED IT.
IT MIGHT BREAK YOUR DB.
IT MIGHT BREAK YOUR INSTALLATION FOR ANY FURTHER UPDATES.

you've been warned.
 
if (unsensibly enough) still being interested take a look here:

http://marc.free.net.ph/mbox/20031215.123203.713ec3e1.txt

but don't ever come and blame me.

good luck

cu
andreas

__________________________

Andreas Wahlfeldt
subshell GmbH
Margaretenstraße 43a
20357 Hamburg

t +49.40. 431 362-25
f +49.40. 431 362-29
e awahlfeldt(at)subshell.com
__________________________ 


Message: 6
Date: Tue, 02 Nov 2004 10:24:47 -0600
From: "Matthew D. Stevens" <matt at netjam.net>
Subject: [rt-users] Purge Tickets
To: rt-users at lists.bestpractical.com
Message-ID: <4187B4CF.8040408 at netjam.net>
Content-Type: text/plain; charset="iso-8859-1"

Hello!

I use a RT2 system with approximately 40,000 tickets.  The system has 
become extremely slow so I would like to purge all of the tickets and 
only keep tickets from 1 year ago to present.  I'm not quite sure how to 
do this so any help or suggestions would be much appreciated.

Thanks,

Matthew

-- 
--
Matthew D. Stevens
matt at netjam.net
Sales and Purchasing

Netjam, LLC               http://www.netjam.net
333 Texas St.             VISA/MC/AMEX/COD
Suite 1401                90 day warranty
Shreveport, LA 71101      Cisco Channel Partner

p: 318-212-0245
f: 318-212-0246
Toll Free: 866-2-NETJAM
AIM: Matt at Netjam