Re: Manager Field from LDAP (122 Views)
Reply
Super Advisor
Mahmoud Al-Abgy
Posts: 355
Registered: ‎06-13-2009
Message 1 of 3 (155 Views)

Manager Field from LDAP

Hi all,
I developed a connect it scenario that retrieves LDAP users with details to SM using ldap connector and SM web services connector but the problem is that the manager field is populated from AD to SM with all path like this one
CN=Administrator,CN=Users,DC=xxx,DC=xxx,DC=xxx
see attached image.
so is there any way to parse this from connect it so i can only populate the user name of manager only ?
Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 57
Registered: ‎01-05-2012
Message 2 of 3 (129 Views)

Re: Manager Field from LDAP

RetVal=UCase(RightPart(LeftPart([manager],",OU=",0,"CN=",0))

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 57
Registered: ‎01-05-2012
Message 3 of 3 (122 Views)

Re: Manager Field from LDAP

RetVal=UCase((RightPart(LeftPart((Replace([manager],"\","")),",OU=",0,"CN=",0)))

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation