<div>
Name the top of the column that has the samaccountnames- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Samaccountname<br />
<br />
Import-Csv 'filelocation\nameofcsv.cs<wbr />v | %{Get-ADUser $_.Samaccountname -properties * | &nbsp;Select DisplayName,SamAccountname<wbr />,whencreat<wbr />ed,LastLog<wbr />onDate,@{N<wbr />='<br />
LastLogon'; E={[DateTime]::FromFileTim<wbr />e($_.LastL<wbr />ogon)}}, @{N='Days Since Last Logon'; E={$($(Get-Date) - $([DateTime]::FromFileTime<wbr />($_.LastLo<wbr />gon))).Day<wbr />s}}
</div>


gd6627

<div>
Since I was already writing it I decided to post it, but @fox Should get the points. Should be noted however that my script completes the export-csv as well..
</div>


<div>
Here's the PowerShell command:<br />
<br />
Get-ADUser &lt;UserName&gt; -Properties whenCreated | Format-List Name,whenCreated<br />
<br />
Checkout quick reference guide we created about AD auditing - it includes instructions and event IDs:<br />
<br />
<a href="http://www.netwrix.com/download/documents/Native_AD_Auditing_Cheat_Sheet.pdf" rel="ugc">http://www.netwrix.com/download/documents/Native_AD_Auditing_Cheat_Sheet.pdf</a><br />
<br />
You can simply use dsquery * command: <a href="http://technet.microsoft.com/en-us/library/cc754232(v=ws.10).aspx" rel="ugc">http://technet.microsoft.com/en-us/library/cc754232(v=ws.10).aspx</a><br />
<br />
For formatting to readable format, use w32tm /ntte to format the output of your dsquery command.<br />
<br />
For more info here: <a href="http://social.technet.microsoft.com/Forums/en/ITCG/thread/19d35656-2be4-4665-822e-34c111e07da2" rel="ugc nofollow">http://social.technet.microsoft.com/Forums/en/ITCG/thread/19d35656-2be4-4665-822e-34c111e07da2</a><br />
<br />
If you want to get the exact date for the last logon, you can query lastlogon attribute (which is not replicated) on each DC and keep only the highest value of the queries as it represents the last logon.<br />
<br />
For Powershell scripting, this should help: <a href="http://blog.mattvogt.net/powershell-last-logon-timestamp-for-single-ho" rel="ugc">http://blog.mattvogt.net/powershell-last-logon-timestamp-for-single-ho</a><br />
<br />
And if you want to dig further and understand who created it (and possibly why), NetWrix AD Change Reporter ( <a href="https://www.netwrix.com/active_directory_auditing.html" rel="ugc">https://www.netwrix.com/active_directory_auditing.html</a>&nbsp;) can be of great value for you (the tool audits who changed, created or deleted what AD object, when and where)
</div>


<div>
@Fox Am getting the following error:<br />
<br />
ERROR: Import-Csv : Cannot bind parameter 'Delimiter'. Cannot convert value &quot;LastLogon;<br />
ERROR: E={[DateTime]::FromFileTim<wbr />e($_.LastL<wbr />ogon)}}, @{N=Days&quot; to type &quot;System.Char&quot;. Error: &quot;String must be exactly one character long.&quot;<br />
GEtUSerStatus.ps1 (16, 70): ERROR: At Line: 16 char: 70<br />
ERROR: + ... DisplayName,SamAccountname<wbr />,whencreat<wbr />ed,LastLog<wbr />onDate,@{N<wbr />='LastLogo<wbr />n';<br />
ERROR: + &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ~~~~~~~~~~~<br />
ERROR: &nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: InvalidArgument: (:) [Import-Csv], ParameterBindingException<br />
ERROR: &nbsp; &nbsp; + FullyQualifiedErrorId : CannotConvertArgumentNoMes<wbr />sage,Micro<wbr />soft.Power<wbr />Shell.Comm<wbr />ands.Impor<wbr />tCsvComman<wbr />d<br />
ERROR:
</div>


<div>
gd6627,<br />
<br />
Please try mine and let me know the output or errors associated with it.
</div>


<div>
Ok @ItGuy565 trying now , Thanks
</div>


<div>
since you are using a $content &nbsp;do I need a header in the csv file for samaccount?
</div>


<div>
Fox is there a way that the output can be ina CSV file format ?
</div>


<div>
Can you explain what the Letter E= and N= stand for
</div>


<div>
@ITGuy565 &nbsp;am getting the following as a result heres a sample the &quot;last logon in days&quot; columm is blank all the way down and the &quot;last logon day has some big numbers &nbsp;please see attached sample<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/04_w17/1305015/testoutput.xlsx" target="_blank" class="file-inline" title="output file after runing script (12 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>testoutput.xlsx</a>
</div>


testoutput.xlsx

<div>
I did receive to good solutions but I had questions that were never followed up on
</div>


<div>
<div class="content wysiwyg-content">
I have a CSV file with samaccountnames &nbsp;- I want to run it thru Powershell to check to see when the users account was created , the last logon time stamp and days since it last log on <br />
then have it exported to a csv file
</div>
</div>


I have a CSV file with samaccountnames  - I want to run it thru Powershell to check to see when the users account was created , the last logon time stamp and days since it last log on 
then have it exported to a csv file

GEt USer activity from AD

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.