How to sync employee information with Active Directory

[Vladislav Belyaev]

Hello community!

I recently started working with Jira. The team was restructured and the employee who was responsible for setting up JIRA quit.

That employee was able to partially set up syncing with Active Directory. Jira gets username, password, e-mail and full name from the directory. We also sync the Jira user directory with the Confluence system. There is a need to pull data such as phone number, position, and organization from AD.

In this regard, I have two questions.
1) How can I set up synchronization of the JIRA user directory with the Active Directory in order to get information about an employee (phone number, position, organization, and if possible even pull up the profile photo)?

2) Where is the user information stored in the JIRA database? I mean the position, the phone number, the organization where he works. If I can't sync with AD, I'd like to try to put this information in the database

Maybe someone has already faced a similar problem. I would be grateful for any information

P.S. I Noticed that Confluence has the fields listed above in the user profile. But I can't edit them, because it syncs with the Jira user rating and my account belongs to this directory.

[Radek Dostál]

Hi Vladislav,

You might be interested in checking out this one: https://jira.atlassian.com/browse/JRASERVER-6354

A lot of comments that could point you in the direction you need.

From my initial view, a few pointers:

 - users in Jira and Confluence only really are built of several things (displayName, emailAddress, username)

 - anything else you want to "connect" with them needs to be something separate, such as user properties

Users are in the 'cwd_user' table and avatars in 'avatar' - you can see the DB schema here https://developer.atlassian.com/server/jira/platform/database-schema/ but I would generally try not to brute-force it through SQL - there are easier, more reliable ways.

The avatar files themselves are stored in {{ jira_home}}/data/avatars on the file system.

All in all though, I would say think through first how you want to be using that information - i.e. what is the main practical use case, because one way would be to sync the data somehow to some user properties (plugins I would say), and another is using that data somewhere outside of user profiles (e.g. searchers on fields, automatic value assignment and such, sms notifications, who knows).

//R