Re: Manager Field from LDAP (170 Views)
Reply
Super Advisor
Mahmoud Al-Abgy
Posts: 360
Registered: ‎06-13-2009
Message 1 of 3 (207 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 ?
Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 2 of 3 (177 Views)

Re: Manager Field from LDAP

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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 3 of 3 (170 Views)

Re: Manager Field from LDAP

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

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.