User Location Field from LDAP?

[jesusemelendezm]

Hi SN developers,

How are you mapping or calculating this field from LDAP location related fields?

Thanks for your input.

Jesus

[shashankjoshi]

Hi Jesus,

go through the below link.

it is a very good solution given by Deepak Ingale to load locations in servicenow   to user records when you are integrating AD into servicenow.

LDAP Integration - Load Locations and Departments along with user records.

it will not update user location city , street, etcetc.. but whenever there is new entry of location. it will create the new location as well.

Regards,

Shashank Joshi

[Deepak Ingale1 · Accepted solution]

Thank you Shashank for giving reference of the blog for LDAP.

Jesus Melendez, User attributes object stores Location information across different AD attributes like st (for state), c (for country), physicaldeliveryofficename (for City) and streetaddress for (Street).

I have created a transform map so that, based on these attributes, map will automatically create a parent child relationship across different attributes.

e.g. Country would be the parent for state and state would be the parent for city and so on.

Moreover, when you open up the user record, on the location field, you will have it displayed as the combination of (streetaddress + city + state). I have also taken care of any of these 3 missing entries. For that I had to create 2^3 = 8 combinations of if and else statements.