How is the cmn_department table populated?

[benbenjamin]

I cannot find the script or scheduled job that is populating the cmn_department table.

[robpickering]

This is usually being populated as part of your LDAP Import, mapping user's departments and inserting them into the table.

-Rob

[benbenjamin]

I was just not aware that the transform map will automatically update the table of a reference field on the target import table. thanks.

[Michael Ritchie · Accepted solution]

Well the good news is you have total control what happens!   See the choice action documentation here:

https://docs.servicenow.com/bundle/istanbul-servicenow-platform/page/script/server-scripting/task/t_...

Yes bad name but it also sets what happens on reference fields as well. By default it is set to create but you can set to ignore, meaning it won't create one if it doesn't exist.

[Rajkumar Sakth2]

@Michael Ritchie - Thanks much. I've been struggling to find out the source of these new records created through LDAP, since in the noon. you made my day. Thanks again. Cheers.