July 10, 2012

DataTable DataView Sort


$dt = new-object System.Data.dataTable

$dt.Columns.Add("Name") | Out-Null
$dt.Columns.Add("size", [int]) | Out-Null


$row = $dt.NewRow()  
$row["Name"] = "Test"
$row["size"] = 10
$dt.Rows.Add($row)


$row = $dt.NewRow()  
$row["Name"] = "Test 2"
$row["size"] = 20
$dt.Rows.Add($row)


$dw = New-Object System.Data.DataView($dt)
$dw.Sort="size DESC"


$dw | Format-Table -AutoSize  # Or $dw | Out-GridView

$dt.Close
$dw.close



Output


Name   size
----   ----
Test 2   20
Test     10

July 2, 2012

How to get PowerShell version

write-host $host.version

Clear all events in all windows eventlogs (must be run as administrator)


Get-EventLog -list | foreach { Clear-EventLog $_.Log }

Sort folder after date (dir /od)

 get-childitem | sort-object LastWriteTime

Exchange 2010 - Dump all SMTP addresses

Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | out-gridview