Service Manager / Service Center Practitioners Forum
cancel

Manager Field from LDAP

Mahmoud Al-Abgy
Outstanding Contributor.

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 ?
2 REPLIES
JosieJosie02
Super Contributor.

Re: Manager Field from LDAP

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

Highlighted
JosieJosie02
Super Contributor.

Re: Manager Field from LDAP

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