Working with Event Logs - Professional SQL Server 2008 Administration with Windows PowerShell - page 133

Figure 6-17
Figure 6-18
You could also use date ranges and sort the results. For example, the following will find all the error
messages generated on January 27, 2009 (see Figure 6-19):
Get-EventLog -LogName "Application" | Where-Object {$_.EntryType -eq "Error"} |
Where-Object {($_.TimeGenerated -gt "2009/01/27") -and ($_.TimeGenerated -lt
"2009/01/28")} | Sort-Object TimeGenerated -descending | Format-Table -auto
Figure 6-19