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
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
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
(
external_entities.name
propertystring,
propertyentry,
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\";";
It looks like you're new here. Sign in or register to get started.
