Location from Active Directory

[dvientos]

Hello all,

I am in the process of putting together my incident management process (OOB) and currently we have our active directory linked and are utilizing SSO to get into SNOW.

Within my Incident Management form I can click the search and it will allow me to search all records which are from our Active Directory. Once I choose a person the location field is automatically grabbing the City field from our active directory and automatically populating the field. Now this is great, however within our AD not everyone's city is filled out or accurate. We do however have a parameter within the AD which is updated everyday with a users city location. (WorkLocationCode)

How do I re-point the location to grab the AD parameter which has the correct city location?

Thanks

D.

[Mark Laucus]

I would recommend looking at the transform maps to change that value.   The here is a quick view of the process.

1. Modify your LDAP attributes to bring in your the WorkLocationCode.   This is done on the LDAP Server record
2. Update the Table Transfor Map for the LDAP User so you can link the u_workLocationCode field in the transform table to the Location in the user record

Look at the article below for more information.

Setting up the LDAP Import Map - ServiceNow Wiki

Mark

[dvientos]

I can get to the field map and I see the Target Field is set to "Default Location". When I click on the drop down box it does not show me the field that I am looking to replace it with. I'm not sure if this is what you mean by link the WorkLocationCode field.

D.

[Mark Laucus]

Good afternoon Domenic,  

Try these instructions:

• First item to do is to identify the attribute in your LDAP directory that WorkLocationCode is mapping to.   It could be a extended attribute in active directory (extensionAttribute).
• Once you have identified that attribute, you need to update the LDAP Server entry (field is named Attributes) where you will add the new attribute you want to import (identified above).
• Next step is to run a directory sync, this activity will update your transform table with the new field you added in the Attribute field for the LDAP sync.
• After the sync is complete, open the AD User Transform map, use the mapping assist ui action to look at what fields are linking and find your location field.   The field selections on the left side of the screen should show your new field.   If so then you can link it to your location field on the right.

I hope this helps

Mark

[Tom Alday]

Open up your Transform Map under System LDAP > Transform Maps and under Field Maps change the Source field to the new WorkLocationCode field. Then run the transform.

Make sure you coalesce on a unique field like username so it updates all user records with the data from new field and doesn't create new accounts.