topic Re: active directory LastLogon in Developer

active directory LastLogon

danielbreton — Mon, 07 Mar 2016 21:57:14 GMT

How can I convert Active Directory Last Logon to a readable date?

Active Directory stores date/time values as the number of 100-nanosecond intervals that have elapsed since the 0 hour on January 1, 1601 until the date/time that is being stored. The time is always stored in UTC.

I would like to display the date in EST.

Thanks

Re: active directory LastLogon

danielbreton — Mon, 07 Mar 2016 22:51:58 GMT

Found it

Last Logon = IF(user[user.lastlogon]>0, user[user.lastlogon]/8.64*10^11)-109205, DATE(2000,01,01))

Re: active directory LastLogon

Brian_M — Thu, 15 Sep 2016 18:14:17 GMT

Hi Daniel, can I ask are you querying AD on prem or is it Azure AD? I'm having trouble getting the domain and credentials right for the initial get data step. Any help would be much appreciated!

Re: active directory LastLogon

cooldood — Fri, 13 Jul 2018 09:42:41 GMT

Thank you so much everyone. I am puulling the computer object and I can get the last logon date, I am looking for the last logon name. Or mayeb a list of all users who have logged into that machine

I am connecting to AD by going to data source other cna picking AD and my current domain auto poulates