Technician Showing Twice when Assigning Requests

Technician Showing Twice when Assigning Requests

We have a technician who is showing twice when we assign requests to him. In addition, he cannot see all the requests assigned to him. What SQL Query can I run to show me the ID's associated to a technician's name?

                  New to ADSelfService Plus?