Remove Default Technicians
We removed the original default technicians (Heather Graham, Howard Stern, etc.) from our technician list however they still show in the drop-downs to assign requests as well as the Technician Auto-Assign (but NOT in the list to exclude techs).
How can i cleanse these phantom technicians from my system?
We tried a SQL command we found in the forums but they still show.
[delete from ci where ciname='Heather Graham' or ciname='John Roberts' or ciname='Jeniffer Doe' or ciname='Shawn Adams' or ciname='Howard Stern']
We're on 9.3 Build 9301 with MS SQL database
Thanks for any assistance.
---
UPDATE - RESOLVED
Found two SQL tables dbo.Aaa.User and dbo.CI that had the techs listed.
Removed techs from the lists and round robin by running:
DELETE FROM dbo.AaaUser
WHERE [USER_ID]=5
{change User ID to 5, 6, 7, 8, 9 (well in our case those IDs) to remove all the techs}