Need to map the managed by field from Active Directory to the group table manager field

[daniellethomson]

We utilize the managed by field in AD for Security Group approvals. I have this field mapped to populate the manager field on the sys_user_group table but AD populates this field based on the users OU. Our issue is that ServiceNow is not reading this as a user and is creating new user records. Our infrastructure team believes this cannot easily be changed to first name last name in AD. So, my question, how do we get ServiceNow to read this field as a user or should we be pulling another field from AD to populate the manager of the group?

[Michael Fry1]

And you have source mapping in Transform Map:

[daniellethomson]

Yes, that is showing. It looks like two records updated correctly last night after expanding the max length of the managed_by field as you suggested but the rest of them didn't update. I did open a HI ticket this morning.

[Michael Fry1 · Accepted solution]

Did you try make it larger again and Executing a scheduled import?

[daniellethomson]

I put it at 5000 last night. I can't imagine our DN is any longer than that. HA!

[Tejashvi]

Hi @Michael Fry , what if we have custom target table ?

Do we need to create this Source field in custom table also or something else need to be done so that it get only user name and not whole AD things?

Please assist and thanks in advance .