$Date = (Get-Date).AddDays(-1)
Get-WinEvent Application | Where-Object {$_.TimeCreated -ge $Date -and $_.ProviderName -eq "MSSQLSERVER" -and $_.Message -like "*journal*"} | Format-List TimeCreated, LogName, Level, LevelDisplayName, Id, ProviderName, Message