Get user values from Active directory

[Szymon Bieńkowski]

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)

[Angelin]

Hi Szymon,

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

Thanks

[Licences AKMF]

Hi Angelin,

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

[Angelin]

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

[Licences AKMF]

Hi,

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

[Fadi Aljabali]

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()

}

[Szymon Bieńkowski]

Hi Fadi,

unfortunately I have the same :)