It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can we add email addresses for AD users using SQL into the JIRA database

Shari Barchus Jun 05, 2017

We have some people in AD whose records are 'contacts' and not 'users', and there is no email associated to them for this reason in their JIRA user account.  If we were to add the email addresses directly into the JIRA db (by SQL) would they persist after the next AD sync (I am thinking the blank record in AD email address field might overwrite the manually entered data in the email address fields in JIRA).  Looking for advice on the best way to do this and want to make sure the data persists after re-indexing and/or a JIRA restart, and future AD Sync's.

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough [Adaptavist] Community Leader Jun 05, 2017

Standard advice - never update an Atlassian application's database directly.  It will almost always go wrong.

In this case, it's a moderately simple update, and, although it will work if you follow the usual SQL path (Stop JIRA, back it up, run the SQL, start JIRA and re-index if you've touched index-related data), you are right about the next update.

JIRA just acts as a local cache when you have external directories.  Every update from AD is going to overwrite your local data, because it is just a cache.

You need to give these contacts email addresses in AD if you want them to have emails in JIRA.

Shari Barchus Jun 05, 2017

Thanks Nic!!

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

841 views 0 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you