[rt-users] Shredding users

2009-11-17 Thread G.Booth
Hi Got a quick query regarding the shredder. Im trying to move a users cases to a different user and then shred the first user, using: rt-shredder --plugin Users=name,user;status,any;replace_relations,user-old This does everything I want except it still shreds the tickets, whereas I only

Re: [rt-users] Shredding users

2009-11-17 Thread G.Booth
I guess your best bet would be to change the owner of the tickets first before running the shredder tool? Andy Hi Andy Id like to change the histroy in the ticket so user becomes user-old throughout, sadly changing the ticket owner doesnt do this :-[ regards Garry ps I tested this on

Re: [rt-users] Shredding users

2009-11-17 Thread Andy Millar
On Tue, 2009-11-17 at 15:05 +, G.Booth wrote: This does everything I want except it still shreds the tickets, whereas I only wanted to get rid of the original user account and preserver the tickets with another user. Does anybody know if theres a way to do this through the shredder

Re: [rt-users] Shredding users

2009-11-17 Thread Andy Millar
On Tue, 2009-11-17 at 15:50 +, G.Booth wrote: Id like to change the histroy in the ticket so user becomes user-old throughout, sadly changing the ticket owner doesnt do this :-[ Then I suspect shredder is the wrong tool. Have you considered just renaming all the users using the RT API?

Re: [rt-users] Shredding users

2009-11-17 Thread G.Booth
On Tue, 17 Nov 2009 08:30:49 -0800 Ken Crocker kfcroc...@lbl.gov wrote: G.Booth, You could also use the SQL native to your DataBase and do it manually. However, keep in mind that it is a RISKY business. You must be sure that whatever UserID you change the info to REALLY exists, or your

Re: [rt-users] Shredding users

2009-11-17 Thread Ken Crocker
G.Booth, Yep, that seems odd. I've done most of my changes to the USERS Table manually in the past. WAY too intense! I'm hoping to move over to shredder with the 3.8.6 version we're about to test. Kenn LBNL On 11/17/2009 9:56 AM, G.Booth wrote: On Tue, 17 Nov 2009 08:30:49 -0800 Ken

[rt-users] Shredding Users wipes out a Ticket - bug?

2009-10-01 Thread Gary Hall
I have a script executed by a cron job that is intended to remove unprivileged Users who are not Watchers from the DB. The Shredder command it generates looks like this: /opt/rt3/sbin/rt-shredder --force -sqldump /opt/rt3/var/data/RT-Shredder/Users/2009-10-01-7384.sql --plugin