Update email address for a user in MS SQL Database

[Gnanabaskar]

Hi All,

We are using external user directory (Microsoft Active Directory). I found many users are not having email addresses, which results in error during JCMA user migration to Cloud. 

I used this query to find the user :

Select * from dbo.app_user where user_key='Pradeep'

I want to update /add email address for this user. What is the MS SQL query we need to execute and Do we need to stop Jira before the update of email ID.

Kindly assist.

Thanks,

Pradeep

[Petr Sýkora]

Hi,

As far as I know, the email address is stored in the table cwd_user and you can set it there. 

We recently went through a user migration at one of our customer, so if you need assistance, maybe we could help you with that.

Petr