Duplicate users while importing from AD
Use the below queries;
To find the number of duplicate users:
SELECT objectguid, COUNT(*) TotalCount FROM aduser GROUP BY objectguid HAVING COUNT(*) > 1;
SELECT userid, samaccname, objectguid, COUNT(*) TotalCount FROM aduser GROUP BY userid, samaccname, objectguid HAVING COUNT(*) > 1;
To update the local user to AD user please use the below query,
update aduser set userid="local userid" where samaccname='XXXX';
To find the number of duplicate users:
SELECT objectguid, COUNT(*) TotalCount FROM aduser GROUP BY objectguid HAVING COUNT(*) > 1;
SELECT userid, samaccname, objectguid, COUNT(*) TotalCount FROM aduser GROUP BY userid, samaccname, objectguid HAVING COUNT(*) > 1;
To update the local user to AD user please use the below query,
update aduser set userid="local userid" where samaccname='XXXX';
New to ADSelfService Plus?
Related Articles
How to configure SAML with Azure AD
This guide will help us configure SAML for users who want to use Azure AD as their IdP and also give you insights on a few issues that you might run into while configuring SAML in an Azure Environment. In an ideal environment, customers will have an ...To find the details about number of users logged in to the application and other related informations
In order to find the details about the list of users logging time to host, their logout time and current status of their connections. Please use the below query, select aas.session_id "SessionID", aal.name "User Name", aas.user_host "User Host", ...Login Frequency Query Report
The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP ...Reject unregistered users mail and notify them
Usecase : Organizations dont want to handle/fetch unregistered contacts mails into the application. They also want to notify the end user when they send email stating The Request raised by you is rejected. Kindly send mail from the registered email ...Exporting and importing requests in SCP using xls format
Step 1 : Generate a report as xls file * Go to Reports module and choose New Custom report, select Requests module and proceed to the report wizard. * Select the required fields (columns) and run the report. You might choose the Request ID as well, ...