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

The C:\PowerServer3_sqlevents.csv file can be opened in Excel, as shown in Figure 6-22.
Figure 6-22
You could export the same SQL Server events to an XML file, as shown in Figure 6-23. Here, you use the
cmdlet Export-Clixml to export the output of all the cmdlets before the pipeline:
Get-EventLog -LogName "Application" -computername PowerServer3 | Where-Object
{$_.Source -like "*SQL*"} | Where-Object {$_.EntryType -eq "Error"} | Export-Clixml
C:\PowerServer3_sqlevents.xml
Figure 6-23
The PowerServer3_sqlevents.xml file can be opened with any browser that is compatible with XML
browsing (see Figure 6-24).