On Thu, Mar 26, 2009 at 08:56:24AM -0400, Josh Greenberg wrote: > I am in the middle of a rt2 to rt3 migration and I was wondering if its > possible to purge all the dead tickets from the database easily. I'm > sure I could perform a query that would find dead tickets in the Tickets > table but I doubt that would get rid of all the other references to > those tickets in other tables. I ask because more than half of our > database is dead tickets sent in by spammers in the days before we had a > good spam filter. It would be nice to trim it down to a reasonable size. > Ideally, I'd like to get rid of all the users that are associated with > these tickets as well. Is there a nice clean way to do this? Thanks. > > Josh
Josh, It will be easier to just move to RT 3 and then run shredder from there then to try and delete them in RT 2. Cheers, Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
