Resigned technician showing up in technician list
Hello,
I had added a technician a few months back, deleted that technician and later had to re-add that same user to become a technician. The technician shows up twice on the "Assign" list and is not getting all of the assigned tickets as it maybe going to the resigned userid. I have run
select au.first_name"Technician",hc.technicianid"Technician ID",sd.status"Status" from helpdeskcrew hc left join aaauser au on au.user_id=hc.technicianid left join sduser sd on sd.userid=au.user_id;
and it shows the same user twice, one active and the other resigned. How can I get the resigned userid taken off the "Assign" list or delete the resigned user entirely?
I had added a technician a few months back, deleted that technician and later had to re-add that same user to become a technician. The technician shows up twice on the "Assign" list and is not getting all of the assigned tickets as it maybe going to the resigned userid. I have run
select au.first_name"Technician",hc.technicianid"Technician ID",sd.status"Status" from helpdeskcrew hc left join aaauser au on au.user_id=hc.technicianid left join sduser sd on sd.userid=au.user_id;
and it shows the same user twice, one active and the other resigned. How can I get the resigned userid taken off the "Assign" list or delete the resigned user entirely?