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 : ...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 ...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 ...Query to get the user details (both technicians and requesters) account-wise with User ID (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) Tested in builds : 14000, 14201, 14301 1) Query to get the First Name, Last Name, Display Name, Login User ID, Login Name, Email and Phone Number of all users in the application, account-wise, with the ...