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.
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:
but don’t ever come and blame me.
t +49.40. 431 362-25
f +49.40. 431 362-29
Message: 6Date: Tue, 02 Nov 2004 10:24:47 -0600
From: “Matthew D. Stevens” firstname.lastname@example.org
Subject: [rt-users] Purge Tickets
Content-Type: text/plain; charset=“iso-8859-1”
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.
Matthew D. Stevens
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
Toll Free: 866-2-NETJAM
AIM: Matt at Netjam