Email id already exists issue
It wont allow you to create a contact, says 'email already exists'.But wont be listed in contact list view,support list view,Acc manager list view
select * from aaacontactinfo where emailid='email@email.com';
This will give you the contactinfo_id , take this id and find the contact id in the following query
select * from aaausercontactinfo where contactinfo_id=303
This will give you the user id. If you fail with above,
select * from sduser where secondemailid='email@email.com'
this will give you the contact id of the email exists in the secondary email id.
Now edit any contact and put this user id in the address bar.Here you could edit or delete the hidden contact.
As a single query to find the status of the user , use the following query
select * from aaausercontactinfo auci join aaacontactinfo aci on auci.contactinfo_id=aci.contactinfo_id where aci.emailid='emailaddress'
select * from aaacontactinfo where emailid='email@email.com';
This will give you the contactinfo_id , take this id and find the contact id in the following query
select * from aaausercontactinfo where contactinfo_id=303
This will give you the user id. If you fail with above,
select * from sduser where secondemailid='email@email.com'
this will give you the contact id of the email exists in the secondary email id.
Now edit any contact and put this user id in the address bar.Here you could edit or delete the hidden contact.
As a single query to find the status of the user , use the following query
select * from aaausercontactinfo auci join aaacontactinfo aci on auci.contactinfo_id=aci.contactinfo_id where aci.emailid='emailaddress'
New to ADSelfService Plus?
Related Articles
Unable to add support rep in v11 - Error: User with the same email id exists
Follow the steps below to rectify this issue. 1. Under the contacts module, click on All Contacts view. Try searching if there is any contact with the same email address by mentioning it in the Primary email, and see if you are able to find any ...Change the default font-size and font-family while sending emails from SCP
Kindly try the following steps below, Access the database and initiate the query below select * from globalconfig where category = 'rta'; It will list out the global config categories and from the list check for the globalconfigid for font -size and ...Set Request Id to start from a particular number - Version 11.0.
Regarding the First Portal (General), you can use the below steps to change the Request Id to start from 136000. 1.The below Select Query will give the last active ticket ID. Select * from SeqGenState where seqname='WorkOrder.WORKORDERID'; 2.Then, ...Domain name changes to Local Authentication , when user is not associated to the default portal. (ID 6117) - Fixed in 14506
Case: Specific users alone (support reps) when trying to login with AD login, the domain name changes to local authentication automatically. Observation: When this user is not associated with the Default portal, their domain names changes to Local ...Backup Issue - Stream closed error
Backup Error - Stream closed error : I request you to follow the below steps and take a trimmed back and check the case. 1. Shut down the application. 2. Edit the backUpData.bat (present under SupportCenter\bin folder) and tune the backUpData.bat as ...