Maximo Open Forum

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

  • Customizations
posted 05-11-2021 04:27
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?
Maximo Certified
Hello,
Are you able to save this string <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"/>  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 Certified
Meanwhile, have you added entry in UserMapping parameter for both <attribute>LDAP TAG FOR MANAGER</attribute> &  corresponding tag in <table> tag?