Script: How to get SQL Server messages from Windows Event Viewer?

on

 $startDate = '2024-08-10'

$endDate = '2024-08-11'


Get-EventLog -LogName "application" `

| Where-Object {$_.source -like "*SQL*" -and $_.TimeGenerated -ge $startDate -and $_.TimeGenerated -lt $endDate } `

| Select-Object source, EntryType, TimeGenerated, Message

Comments

Post a Comment