Get user values from Active directory

Szymon Bieńkowski May 11, 2021

Hi,

 

if someone was wondering how do get values from AD with Scriptrunner, f.e. get manager of Reporter, here you have:

1. You must configure connection with your AD in Scriptrunner - tab Resources.

2. Create Custom Field to display value (in my script is "Przełożony" field)

3. Add script in Listeners:

import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.ldap.LdapUtil
import org.springframework.ldap.core.AttributesMapper
import javax.naming.directory.SearchControls
import javax.naming.directory.Attributes
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.ModifiedValue


def Reporter = event.issue.reporter?.displayName
def cf_Manager = LdapUtil.withTemplate('Picker from LDAP') { template ->
template.search("", "cn=$Reporter", SearchControls.SUBTREE_SCOPE, { Attributes attributes ->
attributes.get('manager').get()
} as AttributesMapper<String>)
}

def issue = event.issue as Issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def cf_Przelozony = customFieldManager.getCustomFieldObjects(event.issue).find {it.name == "Przełożony"}
def changeHolder = new DefaultIssueChangeHolder()
cf_Przelozony.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(cf_Przelozony), cf_Manager.toString()),changeHolder)

 

 

6 answers

0 votes
Szymon Bieńkowski April 26, 2022

Hi Fadi,

 

unfortunately I have the same :)

0 votes
Fadi Aljabali February 10, 2022

Hi Szymon  ,

thanks to post this , what is the custom field type you refer to ?

in addition, playing around your script I tried following in console and working well except it shows byte[] for manager attribute while for string attributes it is working well ,

not sure if that something you experienced before or you may help with ? using Active Directory 

 

 

import org.apache.log4j.Logger
import org.apache.log4j.Level

import com.onresolve.scriptrunner.ldap.LdapUtil
import org.springframework.LdapDataEntry
import org.springframework.ldap.core.support.AbstractContextMapper
import org.springframework.ldap.query.LdapQueryBuilder
import org.springframework.ldap.query.SearchScope
import org.springframework.ldap.support.LdapEncoder
import org.springframework.ldap.filter.EqualsFilter
import org.springframework.ldap.core.AttributesMapper

import javax.naming.directory.SearchControls

def log = Logger.getLogger("com.abc")
log.setLevel(Level.DEBUG)

final resourcePoolName = 'my ldap'

 

def managerName = LdapUtil.withTemplate('my ldap') { template ->
template.search("", "(cn=some name)", SearchControls.SUBTREE_SCOPE, { attributes ->
attributes.get("manager").get()
} as AttributesMapper<Object>)
}

log.debug managerName.toString()

}

0 votes
Licences AKMF January 12, 2022

Hi,

 

it won't work in console tab - you must put it in listeners

0 votes
Angelin January 11, 2022

Hi,

I have configured the LDAP connection but still, when I try running the script in the console, neither did get any results nor any errors.

Thanks

0 votes
Licences AKMF January 11, 2022

Hi Angelin,

script is in Listeners tab, but you must have configured Connection in "Resources" tab to your LDAP host.

0 votes
Angelin January 11, 2022

Hi Szymon,

The script you have shared is not working for me. Where exactly you have run this script?

Thanks

Suggest an answer

Log in or Sign up to answer