[rt-users] Shredded the wrong user

[John Arends]

This is a bit of a side question, but why such concern for deleting 
users? I see the same couple of people asking questions about this and 
spending a lot of time dealing with it.

Extra users don't really take up very much space and with good spam 
control the majority of the users created actually have tickets 
associated with them.

Everyone has their reasons for doing things, so I don't want this to be 
viewed as a critical question. I am just curious about what the reasons 
are. In my case I just leave the users alone.

Mathew Snyder wrote:
> I have a script that is *supposed* to skip privileged users when gathering all
> the users that need to be shredded.  Unfortunately, it didn't skip one
> particular user.  I no longer have the .sql file to reinstate the user so had to
> create the user again.  Is there an easy way to find all the tickets this user
> has transactions in reassign them to the "new" user?
> 
> Mathew