Reply
CJH Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎01-31-2018
Accepted Solution

Active Directory user.lastLogon

Hello,

 

I am trying to convert the active directory user.lastlogon and user.lastlogontimestamp to readable date and times.    The command below which I found on the Internet does not appear to be working for me.

 

Help!

 

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


Accepted Solutions
Frequent Visitor
Posts: 3
Registered: ‎12-02-2018

Re: Active Directory user.lastLogon

[ Edited ]

Try the following code:

 

Last Logon = IF( AD_user[user.lastLogonTimestamp] > 0, AD_user[user.lastLogonTimestamp] / 864000000000 - 109205, DATE(2000,1,1) )

 

Make sure you assign the correct data type and that the default summarization is set to don't summarize. You can select the desired format.

AD_timespan.PNG

 

 

View solution in original post


All Replies
Frequent Visitor
Posts: 3
Registered: ‎12-02-2018

Re: Active Directory user.lastLogon

[ Edited ]

Try the following code:

 

Last Logon = IF( AD_user[user.lastLogonTimestamp] > 0, AD_user[user.lastLogonTimestamp] / 864000000000 - 109205, DATE(2000,1,1) )

 

Make sure you assign the correct data type and that the default summarization is set to don't summarize. You can select the desired format.

AD_timespan.PNG

 

 

Highlighted
CJH Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎01-31-2018

Re: Active Directory user.lastLogon

Thank you!!  That did the trick.  

 

A tip for users, I set the last argument to 9999/01/01 to flag that there is no real last logon data available.