Sync AD 'Manager' data with LDAP custom attribute for Maximo Supervisor field

Question

Hi All,
Hope you are doing well in these hard times.

I have a requirement here to Sync Manager data from AD to Maximo Supervisor field.
As I can see, AD is storing the value in the form of 'Person Name' and Maximo stores Supervisor data in the form of 'Person ID', So I thought of creating a new field to store the Manager name and then write a automation script to get the ID and insert it into the Supervisor field.
Here, to make this happen, I added the manager field in the 'VMMSYNC' 'UserMapping' xml and bind it to the newly created attribute to store the manager name.
But, the problem we facing is that manager data is in the form of Identifier:
<wim:manager externalName="CN=Ekwere G. Itang,OU=PHRC,DC=CHQ,DC=NNPCGroup,DC=local"
repositoryId="LDAP" uniqueId="933e78ace9c027438c475f664a26a855" uniqueName="CN=Ekwere G. Itang,OU=PHRC,DC=CHQ,DC=NNPCGroup,DC=local"/>
(Got the above from the debug log of VMMSYNC).
Is there any way to extract the uniqueName or PersonID of the Manager from the above format?

Answer

Hello,
Are you able to save this string repositoryId="LDAP" uniqueId="933e78ace9c027438c475f664a26a855" uniqueName="CN=Ekwere G. Itang,OU=PHRC,DC=CHQ,DC=NNPCGroup,DC=local"/> in database custom field which you have created?

If yes then it already has tag - uniqueName="CN=Ekwere G. Itang ,also there is a separate CN tag available, you can do substring and use this string like in whatever way you want.

Thanks,
Prashant

Maximo Open Forum