I would like to change the Suggested Analyst from a retired Analyst "Analyst A" to a new Analyst "Analyst B". There are a large number of categories where the old analyst is the suggested analyst. I would like to delete this analyst from Service Desk all together, and re-assign all of his categories to a new analyst. I know that it's possible from within SQL to execute a query that will update all category assignments from Analyst A to Analyst B, but I don't know how to do it. Is there documentation that will step me through this?
Thanks in advance for your help!