question Re: Last login time is not captured in the LDAP integration in Developer forum

Last login time is not captured in the LDAP integration

Kiran66 — Tue, 23 Oct 2018 12:22:07 GMT

I have added the last login time attribute to the user form and mapped to the AD filed attribute in the import user table.

However, when we ran the LDAP integration, last login time is not capturing from the AD. For few users it is capturing the system generated time stamp. Could anyone suggest us how to capture the last login time stamp from the AD?

Thank you!

Re: Last login time is not captured in the LDAP integration

Chuck Tomasi — Tue, 23 Oct 2018 12:24:31 GMT

Can you provide additional details on how you are doing your LDAP integration? Specifically, your transform map and transform script(s)?

Re: Last login time is not captured in the LDAP integration

Kiran66 — Tue, 23 Oct 2018 12:40:24 GMT

We have mapped the Source LDAP import table to the sys_user table and mapped the attributes in the transform map.

Re: Last login time is not captured in the LDAP integration

Chuck Tomasi — Tue, 23 Oct 2018 12:56:08 GMT

Thank you. Specifically, what has been mapped to what?

Re: Last login time is not captured in the LDAP integration

Kiran66 — Tue, 23 Oct 2018 13:57:42 GMT

Thanks Thomas for your quick responses.

We only have the issue with the last login filed value as it's not being updated when we ran the LDAP.

We have mapped u_lastlogontimestamp field from the AD to last_login_time in ServiceNow.

Thank you!

Re: Last login time is not captured in the LDAP integration

Jim Coyne — Tue, 23 Oct 2018 14:18:28 GMT

Sorry to step on Chuck's toes, but the "last_login_time" field is populated by a Script Action called "Last login time". It keeps that field updated with the last time the user logs into the ServiceNow platform. If you want to keep track of the last time they logged into AD, I would suggest you create a custom date/time field for that purpose specifically.

Re: Last login time is not captured in the LDAP integration

Kiran66 — Thu, 25 Oct 2018 15:31:47 GMT

I have created a custom date/field and mapped to the AD field name in the Data sources. Still not able to get the date and time information. I have also tried the source code

var Llogin = source.u_lastlogontimestamp;

return "Llogin";

Could you please advise how we can capture the AD last login?

Thank you!

Re: Last login time is not captured in the LDAP integration

Jim Coyne — Thu, 25 Oct 2018 15:52:56 GMT

If you have your variable Llogin in quotes when attempting to return the value, you are actually returning the string "Llogin" and NOT the value of the variable.

Re: Last login time is not captured in the LDAP integration

Jim Coyne — Tue, 06 Nov 2018 07:02:15 GMT

Did you find a solution to your issue? If yes, please remember to tag the correct answer and any that were helpful.

Re: Last login time is not captured in the LDAP integration

Kiran66 — Wed, 14 Nov 2018 07:30:57 GMT

Hello Jim,

We created a custom field and mapped to the lastlogontime on AD. We are getting the value now and the format is different.

We need to convert the format to our ServiceNow format to get inserted into our target field.

Thank you!

Re: Last login time is not captured in the LDAP integration

Jim Coyne — Wed, 14 Nov 2018 16:26:29 GMT

What does the data look like in the import set table for the AD lastlogontime attribute?

Re: Last login time is not captured in the LDAP integration

Kiran66 — Wed, 28 Nov 2018 07:14:57 GMT

Hi Jim,

Sorry for the delay in response.

The value that we are getting to the import set table is "131871081929107968"

I have tried to capture by creating a string custom field and mapped it. It's getting updated.

However, problem in converting and updating the Date custom field.

Code I have written is

var gdt = new GlideDateTime();
var mstime = (source.u_lastlogontimestamp);
gdt.setNumericValue((mstime - 116444736000000000)/10000);
gdt.getValue();
gdt.setDisplayValue(gdt.getValue());
var adt = gdt.getDisplayValue();
return "adt";

Please advise!

Re: Last login time is not captured in the LDAP integration

Jim Coyne — Thu, 29 Nov 2018 20:54:56 GMT

The problem with your script is you are literally returning the string "adt" instead of the value of the variable.

Re: Last login time is not captured in the LDAP integration

Mike Patel — Thu, 29 Nov 2018 20:58:05 GMT

Kiran,

Below is the script that I use to get last login time from AD to SN field.

Transform script onBefore

Script

// Updates the SN last logon field   
var n = source.u_lastlogontimestamp;  
var s = n.toString();  

if (s.charAt(0) == 1) {  
	var dtUtil = new DateTimeUtils(); 
	target.u_last_logon = dtUtil.int8ToGlideDateTime(n); 
}else if(!target.u_lastlogontimestamp.nil()) {  
	target.u_last_logon = '';  
}

Re: Last login time is not captured in the LDAP integration

Kiran66 — Mon, 03 Dec 2018 12:40:47 GMT

Thanks Mike,

I tried the above and it didn't work for me.

However, I have also tried as per the Jim's advise and it worked for me.

Thank you all, for looking into this 🙂

Re: Last login time is not captured in the LDAP integration

Sanbir Singh1 — Wed, 08 Jul 2020 13:27:22 GMT

Kiran - can you share the snapshot of where did you put this script?