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?

[randrews]

check the field length/type on the IMPORT table.. not on the table itself.. remember the data goes to an import table THEN to the final table.

[daniellethomson]

Thanks Raymond,

That is where I updated it. I worked with HI and we had to clear a couple job runs then all the data updated. So fixing the field length and clearing the previous job runs seemed to do the trick.