Modifying Existing Technician / Requester
Hello,
We have couple of issues caused by not being able to modify the login name for the users in the Service DeskPlus.
For example, we have few technicians in the ServiceDesk Plus system which we are trying to modify the details for, but subsequently found out that there are 2 accounts for the user, <username> and <username>@<domain>.
Looking at the LOGIN_ID and USER_ID values in the dbo.AaaLogin table, it seems that the technician was created manually through the ServiceDesk Plus first, with the login as <username>@<domain>, and then the AD was imported by the schedule later, which created a new login as <username>.
The new tech has been using the login of <username>@<domain> since the role was also assigned to that particular login account.
If we login as <username> for that user, it shows a default request dashboard.
It seems this problem has been going on for a while, as there about about 4 techs with this problem.
My question is
1) Is it possible to merge the logins and choose which login ID to use, so we do not lose the history?
For example, we'd like to merge the above users and also to set the login ID of <username> as the tech and delete the <username>@<domain> account without losing the history associated with <username>@<domain>.
2) We had one user (tech) leave and a new user is taking over his role. We'd like him to login with his AD account but have the previous tech's work history to be attached his login.
Is the only way to modify the login ID is via SQL query? If so, could you tell us the correct SQL query or at least what tables need to be looked at?
Thank you
Daniel
We have couple of issues caused by not being able to modify the login name for the users in the Service DeskPlus.
For example, we have few technicians in the ServiceDesk Plus system which we are trying to modify the details for, but subsequently found out that there are 2 accounts for the user, <username> and <username>@<domain>.
Looking at the LOGIN_ID and USER_ID values in the dbo.AaaLogin table, it seems that the technician was created manually through the ServiceDesk Plus first, with the login as <username>@<domain>, and then the AD was imported by the schedule later, which created a new login as <username>.
The new tech has been using the login of <username>@<domain> since the role was also assigned to that particular login account.
If we login as <username> for that user, it shows a default request dashboard.
It seems this problem has been going on for a while, as there about about 4 techs with this problem.
My question is
1) Is it possible to merge the logins and choose which login ID to use, so we do not lose the history?
For example, we'd like to merge the above users and also to set the login ID of <username> as the tech and delete the <username>@<domain> account without losing the history associated with <username>@<domain>.
2) We had one user (tech) leave and a new user is taking over his role. We'd like him to login with his AD account but have the previous tech's work history to be attached his login.
Is the only way to modify the login ID is via SQL query? If so, could you tell us the correct SQL query or at least what tables need to be looked at?
Thank you
Daniel