Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Found it
Last Logon = IF(user[user.lastlogon]>0, user[user.lastlogon]/8.64*10^11)-109205, DATE(2000,01,01))
Found it
Last Logon = IF(user[user.lastlogon]>0, user[user.lastlogon]/8.64*10^11)-109205, DATE(2000,01,01))
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |