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
Clear all events in all windows eventlogs (must be run as administrator)
Get-EventLog -list |
foreach { Clear-EventLog $_.Log }
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
Subscribe to:
Posts (Atom)