RT shredder, data retention

RT Developers
1

I think I asked this question about a year ago. What is the status of
implementing something that allows you to delete tickets from the
database? I know that RT functions on the premise that you can easily
go back and look up old tickets but what about those concerned with
data retention times? We only want to retain data for 6 months to a
year, not for the life of the database. Has anyone developed anything
that allows for removal of tickets from the database? I know there is
RT-shredder but it is far too slow. We could run it continuously and
not get anywhere close to keeping up with day to day tickets never-
mind the backlog we have now.

Thanks,
Alex

2

Shredder is what you want. If it is running slow it is likely that
you need to add some indexes to your tables. The recommended indexes
are here:

Not only do these indexes help Shredder but they will likely improve
your RT performance.

jbwOn 9/26/07, Alex Meyer apmeyer@doit.wisc.edu wrote:

I think I asked this question about a year ago. What is the status of
implementing something that allows you to delete tickets from the database?
I know that RT functions on the premise that you can easily go back and look
up old tickets but what about those concerned with data retention times? We
only want to retain data for 6 months to a year, not for the life of the
database. Has anyone developed anything that allows for removal of tickets
from the database? I know there is RT-shredder but it is far too slow. We
could run it continuously and not get anywhere close to keeping up with day
to day tickets never-mind the backlog we have now.

Thanks,
Alex

List info:
The rt-devel Archives