active directory LastLogon

[danielbreton]

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

[danielbreton · Accepted solution]

Found it

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

[Brian_M]

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!

[cooldood]

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