Service Desk Practitioners Forum
cancel

URGENT: LDAP import issues

Highlighted
Akies
Outstanding Contributor.

URGENT: LDAP import issues

Hi,

I am using below mentioned ini file that imports telephone number, sp account,user's details along with manager of that user from LDAP:

[CONNECTION]

TYPE=LDAP



[LDAP]

SERVER=172.20.0.69

PORT=389

-- PRINCIPAL=cn=vikas tatwani,ou=FDACCESS,ou=others,ou=hutch-del,dc=Hutchindia,dc=com

-- PRINCIPAL=cn=PUSHMAIL DEL,ou=FDACCESS,ou=information system,ou=hutch-del,dc=Hutchindia,dc=com

PRINCIPAL=cn=PUSHMAIL DEL,ou=SERVICE ACCOUNTS,ou=OTHERS,ou=HUTCH-DEL,dc=Hutchindia,dc=com

AUTHENTICATION=simple

CREDENTIALS=hutchmail





[SYSTEM]

LOG=TRUE

XML=TRUE

LOG_FILE=E:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\client\data_exchange\log\LDAPceo.log

XML_OUTPUT_FILE=E:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\client\data_exchange\xml\ldapceo.xml

APPLICATION_NAME=LDAP_Persons





[CLASSES]

NAME=PERSONS, TELEPHONE, SPACCOUNT

---------------------

-- WORKGROUP CODES --

---------------------

[SPACCOUNT]

--SOURCE=ou=FDACCESS,ou=others,ou=hutch-del,dc=hutchindia,dc=com

SOURCE=ou=CEO OFFICE,ou=hutch-del,dc=hutchindia,dc=com

COLUMNS=[sAMAccountName],[CN]

ATT=[sAMAccountName],[CN]

-- See IBM Redbook on SEARCHSCOPE

CONDITION=(&(!(objectclass=computer))(objectclass=person))

[PERSONS]

--SOURCE=ou=FDACCESS,ou=others,ou=hutch-del,dc=hutchindia,dc=com

SOURCE=ou=CEO OFFICE,ou=hutch-del,dc=hutchindia,dc=com

COLUMNS=[CN], [Mail],[sAMAccountName],[title],[Department],[description],[manager]

ATT=[CN],[Mail],[department],[sAMAccountName],[title],[Department],[description],[manager]

-- See IBM Redbook on SEARCHSCOPE

SEARCHSCOPE=SUBTREE_SCOPE

CONDITION=(&(!(objectclass=computer))(objectclass=person))



[TELEPHONE]

SOURCE=ou=CEO OFFICE,ou=hutch-del,dc=hutchindia,dc=com

--SOURCE=ou=FDACCESS,ou=others,ou=hutch-del,dc=hutchindia,dc=com

COLUMNS=[sAMAccountName],[telephoneNumber]

ATT=[sAMAccountName],[telephoneNumber]

-- See IBM Redbook on SEARCHSCOPE

SEARCHSCOPE=SUBTREE_SCOPE

CONDITION=(&(!(objectclass=computer))(objectclass=person))



Now after I import the details in service desk, I get manager details as :



CN=MANOJGARG,OU=SALES,OU=SALES AND MARKETING,OU=HUTCH-DEL,DC=HUTCHINDIA,DC=com



How can I get only manager name instead of full path?

Regards,
Akhil


2 REPLIES
Radovan Skolnik
Acclaimed Contributor.

Re: URGENT: LDAP import issues

Well you won't get manager's name directly - you do not want to ;-)

You are probably importing Persons, right? Each Person can have associated manager Person. In import mapping you have to define a key by which you are looking for that manager Person. If you store a LDAP DN with your persons (for example as a Source ID) that this DN (CN=MANOJGARG,OU=SALES,OU=SALES AND MARKETING,OU=HUTCH-DEL,DC=HUTCHINDIA,DC=com) you map your [manager] attribute to Manager->Source ID. By that SD will associate Person with such Source ID with the current Person.

Sounds complicated but hope you'll eventually understand. To summarize, this mapping is important:
[DN]->Source ID
[manager]->Manager->Source ID
Akies
Outstanding Contributor.

Re: URGENT: LDAP import issues

.