[rt-users] Shredder for requestors?

[Howard Jones]

Hi,

At some point in the past, our RT has had a pretty serious flurry of 
spam, and as a result, I have 201K rows in Principals, 145K+ in each of 
Groups and GroupMembers, and 450K rows in CachedGroupMembers. These seem 
like pretty high numbers to me (we probably have somewhere around 2-300 
active users, at most).

Recently I tried loading the database dump into a new database, and it 
took 31 hours, which is a little concerning.

Does anyone already have a tool like RTx-Shredder to remove "orphaned" 
Principals, and their associated junk? I guess the requirement is 
Requestors who are only associated with deleted tickets, or no tickets 
at all.

Equally, the sessions table has entries going back to 2003 in it - is 
that normal? Shouldn't they expire?

Best Regards,

Howard