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
Email Command Replacement Issue : Replying with 'EditRequest' creates new request
Refernce Ticket : #8115154 Reference Issue : SD-105028 ISSUE : When the user tries to editRequest using email command by replying to the mail received from technician, A new request is added instead of updating the old request. Cause : ...Graph email debug
To debug the email fetching issue in #9967473: The customer signature is not getting fetched properly.Email Commands Not working when Mail is sent from user to Application through a Technician Mailbox by Autoforwarding
Issue : Email Command expected to behave such that email command parameters specified only in the latest message is considered for Request Creation Previously before 14001, Email command utilizes whole message content instead of only latest message ...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 ...Query to know the User details,account,site based on email (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) select aaau.user_id,aaau.first_name, aaaci.emailid,sdu.status, sdo.name "Site", adef.org_name "Account" from aaauser aaau LEFT JOIN aaausercontactinfo aaauci ON aaauci.user_id=aaau.user_id LEFT JOIN ...