When we first started using ServiceDesk we as an organization decided to use Resolved as our closer code for any request that were completed and to rely on Closed when a request could not be fixed.

We've learned recently that Resolved does not retrain the Technician name when a tech leaves. This is making it rather difficult to reference old notes. Is there a SQL script we can use that will update the status and closer code from "Resolved" to "Closed with Success" for any quest that has a status of Resolved?