Reading Todays SQL Error Log With PowerShell

Show-LatestSQLErrorLog fade2black|Out-File -FilePath c:\temp\log.txt
Invoke-Item c:\temp\log.txt
#############################################################################    ################
#
# NAME: Show-Last24HoursSQLErrorLog.ps1
# AUTHOR: Rob Sewell http://newsqldbawiththebeard.wordpress.com
# DATE:22/07/2013
#
# COMMENTS: Load function for reading last days current SQL Error Log for     Server
# ————————————————————————
Function Show-Last24HoursSQLErrorLog ([string]$Server)     {                      
    $srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $server 
    $logDate = (get-date).AddDays(-1)
    $Results = $srv.ReadErrorLog(0) |Where-Object {$_.LogDate -gt $logDate}|     format-table -Wrap -AutoSize 
    $Results         
}
Built with Hugo
Theme Stack designed by Jimmy