Converting LastLogon to DateTime format

Question

My objective is to get a list of users from my domain with the following info   -Display name -Country -Manager Name -Last login date  I am running the following script  and everything looks good except for the LastLogon   It outputs the time into a bunch of random numbers like  129948127853609000    How can I convert this to DateTime format   Search-ADAccount -UsersOnly -SearchBase  OU International DC mycompany DC com  -AccountDisabled  false   Get-ADUser -Properties Name  manager  LastLogon   Select Name  manager  LastLogon   export-csv C  Australia csv -NoTypeInformation

User · Accepted Answer

DateTime FromFileTime should do the trick   PS C   gt   datetime   FromFileTime 129948127853609000   Monday  October 15  2012 3 13 05 PM   Then depending on how you want to format it  check out standard and custom datetime format strings   PS C   gt   datetime   FromFileTime 129948127853609000  ToString  d MMMM   15 October PS C   gt   datetime   FromFileTime 129948127853609000  ToString  g   10 15 2012 3 13 PM   If you want to integrate this into your one-liner  change your select statement to this         Select Name  manager    N  LastLogon   E   DateTime   FromFileTime    LastLogon

User · Answer

Use the LastLogonDate property and you won t have to convert the date time  lastLogonTimestamp should equal to LastLogonDate when converted  This way  you will get the last logon date and time across the domain without needing to convert the result

User · Answer

LastLogon is the last time that the user logged into whichever domain controller you happen to have been load balanced to at the moment that you ran the GET-ADUser cmdlet  and is not replicated across the domain  You really should use LastLogonTimestamp if you want the time the last user logged in to any domain controller in your domain

User · Answer

Get-ADUser -Filter  Enabled -eq  true  -Properties Name Manager LastLogon    Select-Object Name Manager   n  LastLogon  e   DateTime   FromFileTime    LastLogon

[powershell] Converting LastLogon to DateTime format

Examples related to powershell

Examples related to active-directory