Get AD information of users into jira

[Paresh Gandhi]

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

[Daniel Bajrak · Accepted solution]

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

[Andris Grinbergs]

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\";";