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

bgwills · ‎10-07-2014

I am actually having the same issues as you. I will have to take a look and see if I can figure out why that is happening.

jesusemelendezm · ‎10-07-2014

I am still struggling with the same. Let me know if you find out.

ryadavalli · ‎10-01-2015

HI Doug,

I am trying to add a couple of fields to the user table. Our Worker day feed already has it.

so what would be my steps to add to the transform map.

1) Add the fields to the user table

2) do I have to load/change the import set table ? IF so how?

3) The map the fields from import set table to the target table

4) Tranform?