Forum Discussion

danielbreton's avatar
danielbreton
New Member
10 years ago
Solved

active directory LastLogon

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 ...
  • danielbreton's avatar
    danielbreton
    10 years ago

    Found it

     

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

     

     

danielbreton's avatar
danielbreton
New Member
10 years ago

Found it

 

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

 

 

  • Brian_M's avatar
    Brian_M
    Continued Contributor
    9 years ago

    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's avatar
      cooldood
      New Member
      8 years ago

      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