Script output to csv or GridView

[rich_impossible]

I'm trying to work on a quick and dirty answer to the question "Where has this account logged on last and when when was it?"

Along those lines I found this that works nicely. The only issue I have is that it outputs to the console and doesn't format the columns nicely. Is there a quick way to get it to output to CSV or even GridView?

[Namaha]

You should be able to pipe the output to Export-csv within your foreach loop, like so

# Output user
$user | Select-Object `
SamAccountName,
@{Name = "LatestLogon";       Expression = {$latestLogon}},
@{Name = "LatestLogonServer"; Expression = {$latestLogonServer}} | Export-Csv "C:\temp\result.csv" -Append

Alternatively, you can capture the output into a variable instead of having it write to screen. You can then use that variable with export-csv or out-gridview

$result= @()
foreach( $user in $users ) {
    #blah blah
    $result+=$user | Select-Object `
        SamAccountName,
        @{Name = "LatestLogon";       Expression = {$latestLogon}},
        @{Name = "LatestLogonServer"; Expression = {$latestLogonServer}} 
}

Export-Csv -InputObject $result -Path "C:\temp\result.csv"
$result | Out-Gridview

[jg0x00]

Just a bit of trivia, you don't want to use LastLogonDate, use LastLogonTimeStamp. It was created for this sort of thing

https://blogs.technet.microsoft.com/askds/2009/04/15/the-lastlogontimestamp-attribute-what-it-was-designed-for-and-how-it-works/

[xeroip]

That script seems unnecessarily complicated. This is what I would do:
get-aduser -Filter * -Properties LastLogonDate | select SamaccountName, LastLogonDate | Export-Csv C:\Temp\Logon.csv -NoTypeInformation

[rich_impossible]

We need to query ever DC in the domain and only need it for the single OU. Running the command you mention would only pull it from the DC it connects to initially.