Get AD information of users into jira

1st question - is it possible to get contact and location information from active directory user into jira.

scenarion - if some one creates tickets his contact infromation should get copied or auto populated from AD to jira

2 answers

1 accepted

This widget could not be displayed.

You can use add-on Active Directory Integration. It's very easy to use. You can choose user's attributes, get all selected values from AD and use it in JIRA. You can get values from more than one AD or ldap servers.

https://marketplace.atlassian.com/plugins/com.intenso.jira.plugins.ad-integration-manager

This add-on has more possibilities. You can see documentation:

http://plugins.intenso.pl/display/PLUG/Active%20Directory%20Integration%20with%20JIRA

This widget could not be displayed.

You should add Jira user properties from AD. I created a perl script which runs every night and updates Jira user properties in DB from AD.

I use this SQL to get list of users which have have missing user property:

select

name

from

external_entities

where

external_entities.name not in

(

select

external_entities.name

from

propertystring,

propertyentry,

external_entities

where

propertystring.id=propertyentry.id and

external_entities.id=propertyentry.entity_id and

propertyentry.property_key="jira.meta.UserCustomID"

)

Then cycle those users, get value for each with $ldap->search

Then write found values to Jira DB:

INSERT INTO propertystring (id,propertyvalue) VALUES (\@newID, \"$UserCustomID\");";

And update sequence after that:

UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID=(SELECT (((max(id)+20) div 100)+1)*100 from propertyentry) where SEQ_NAME=\"OSPropertyEntry\";";

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

83 views 1 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you