All our Technicians have two accounts. Their regular corporate account they do all their normal corporate functions on and a privileged account they use for administrative rights when working on equipment. Right now all the technician accounts in our system are tied to that administrative account. I was wondering if there is a way to take all the tickets that are currently assigned and have been assigned in the past to say jdoe (AD User) and swap out with user john.doe (AD User) which is their regular account. I would assume there is probably some way of doing that through the SQL backend, just wasn't sure of the queries to run.