Powershell实时监控SQL SERVER错误日志

以下是powershell实时监控SQL SERVER错误日志,通过MSG发送报警信息，代码中“TargetInstance.Type='错误'” 是中文操作系统，如果是其他操作系统注意更改！

$query = "SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA 'Win32_NTLogEvent' and TargetInstance.Logfile = 'Application' and TargetInstance.Type='错误' and TargetInstance.SourceName='MSSQLSERVER'"

#Register WMI event
Register-WMIEvent -Query $query -Action { 
$d=$eventArgs.NewEvent.TargetInstance.Message 
$Message='Server: '+$d
 msg /server:你接收的IP * $Message

}