Users last login time changed after import

[GChanner]

We are converting from Lawson to Workday. Our users profile had changes in WD (company, dept. etc.) so for our cut over we needed to re-load 17800 users from Workday back to SN.

Note: these 17800 users already exist in SN.

The import would have updated the existing users company, dept. fields while coalescing on the email

We found after the re-load some users 'Last login time' go adjusted and some were empty.

The last login time was not part of the import/transform map.

Does anyone know why or how did the 'Last login time' field got updated?

See screen shot of before and after for one of the affected user.

[Abbas_5 · Accepted solution]

Hello @GChanner,
Please check with ServiceNow Hi Team they will help you.

Thanks & Regards,

Abbas Shaik

[Maik Skoddow]

Hi @GChanner 

Indeed, that's strange. Are you able to reprocess from the beginning and disable the checkbox "Run business rules" on the "Transform Map" record?

Maik