Email 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'
Related Articles
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 ...How to take console log ?
This article is common for Servicedesk plus MSP and Supportcenter plus applications. To troubleshoot certain UI issues , JS errors , we need console log (output) from the browser. Steps to follow : 1. Login to the application. 2. Right click on the ...Issue running reports
Cause : Report API running the background causes the issue. If the user mentions issue with running reports with the below error and trace as mentioned below. Error trace: ...Behavior of Survey email configuration in 11.0
When Support reps setup survey email configuration, they would be under the impression that the language they select would the one the survey goes out but it doesn't work that way. Let's say that the Support rep sets up the survey to go out in the ...Email Signtature behavior in Version 11.0.
In order for the email signature to work in Version 11.0, please do add the signature first and then go to Admin - Notification Rules - Replying to a Request template - Customize template and add the below variable $EmailSignature. ...