[SOLVED] Duplicate Technican
We are in the process of cutting over to Office 365 and I am a test user. We are planning to rename our login names (UPN and pre2000) on A\D to make details more uniformed. .
As part of the testing I changed my A\D login name (UPN and pre2000).
To cut a long story short I had to recreate myself in SDP as a technician logging in via the domain. This has resulted in my name showing up 3 times under technicians. In future plan to merge the remaining technicians.
I followed this thread:
https://pitstop.manageengine.com/portal/community/topic/duplicate-technicians however my name is only appearing once.
servicedesk=# select al.user_id"USER ID",au.first_name"NAME",al.login_id"LOGIN I
D",sd.status from aaalogin al left join aaauser au on al.user_id=au.user_id left
join sduser sd on sd.userid=au.user_id where first_name like '%norbert%';
USER ID | NAME | LOGIN ID | status
---------+-------------------+----------+--------
67802 | Norbert LASTNAME| 44701 | ACTIVE
(1 row)
Please help.