Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Manager Field from LDAP

Super Advisor

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
Frequent Advisor

Re: Manager Field from LDAP

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

Highlighted
Frequent Advisor

Re: Manager Field from LDAP

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