Modifying an existing Transform Map

jesusemelendezm · ‎09-08-2014

Hi everyone,

I need to modify a transform map used for LDAP user import. I need to add "user account expiry date" from active directory into the user form of ServiceNow. I have done the following:

1) create a new field "u_expirydate" of date type and added to the user form.

2) from Table Transform Map I created a new field map and select the source field "u_accountexpires" to "u_expirydate"

3) run the scheduled ldap import.

I can't get this field "Expiry date" updated? is there anything else that I need to do additionally?

Thanks,

Jesus E.

chadlockwood · ‎09-09-2014

Go into System LDAP > LDAP Servers > <your ldap server>

Click Browse under Related Links

Enter the distinguishedName of a user that has an expiration date and click Search

See if the accountexpires field appears

What I think you will find is this:

While you see a date/time in ADUC, this field is actually a 64-bit number representing the number of "ticks" since 12:00 AM January 1, 1601. If the accountexpires field is being pulled, it will likely not allow you to shoehorn it into the date field you created on your import table. You will have to change that data type and handle the conversion to a date in your transform map. There is some information about this here:

https://community.servicenow.com/message/652592#652592

View solution in original post

chadlockwood · ‎09-08-2014

Jesus,

In your LDAP Server connection, did you add the accountexpires attribute?

Chad

jesusemelendezm · ‎09-08-2014

yes, I do. I map it to the target field.

chadlockwood · ‎09-09-2014

System LDAP > LDAP Servers > <your ldap server>

In the attributes field, is accountexpires included with the rest of the attributes you are pulling from AD?

jesusemelendezm · ‎09-09-2014

In Attributes I see this

objectguid,company,title,department,l,name,givenname,source,samaccountname,mail,sn,member,employee-type,manager,carlicense,country-name,phone-ip-primary,phone-mobile-primary,mobile,iphone,o,useraccountcontrol,telephonenumber