根据事件日志触发Powershell [英] Trigger powershell based on event log

问题描述

我有一个用PowerShell编写的命令行参数脚本，该脚本接受任务计划程序中的服务器名称.但是，我的要求是在重新启动SQL Server时执行脚本，因此我将PowerShell脚本附加到事件17069.但是，我无法动态传递事件源(在这种情况下为服务器名称).

I have a command line argument script written in PowerShell which accepts server name from the task scheduler. However my requirement is to execute the script when the SQL server is restarted, hence I have attached the PowerShell script to the event 17069. But I am unable to dynamically pass the event source which would be the server name in this case.

下面是任务计划程序作业的参数部分

Below is argument section of the task scheduler job

-Command "& 'D:\SQLJobs\PS\readErrorLogFile.ps1' '$(Source)'"

$(Source)在启动powerShell时未从事件视图中获取事件源.您能告诉我如何获取事件源吗?

$(Source) does not pick up the event source from event view while firing the powerShell. Can you please let me know how to pick up the event source.

正如评论中所建议的，我已使用下面的XML分支更新了我的任务计划程序工作

As suggested in the comments I have updated my task scheduler job with below XML branch

<ValueQueries>
<Value name="server">Source</Value>
</ValueQueries>

上述脚本已插入<EventTrigger>分支中.

The Above script has been inserted in <EventTrigger> Branch.

下面是PowerShell CMD行输入脚本.

Below is PowerShell CMD line input script.

 param (
    [string]$server
 )

请让我知道在任务计划程序作业的参数部分中需要提及的内容，因为$(server)在脚本中显示为空.

Kindly let me know what needs to be mentioned in the argument section of the task scheduler job as $(server) displays null in the script.

推荐答案

我认为您要查找的内容在此处描述:

I think what you're looking for is described here:

• 根据事件创建任务后，需要在任务计划程序"中右键单击该任务，然后执行导出.."以将其另存为XML.然后修改XML，以包含要发送到脚本的值的值查询(在<EventTrigger>部分中).

  After you've created your task from the event, you need to right click it in Task Scheduler and do Export.. to save it as XML. Then modify the XML to include value queries for the values you want sent to your script (within the <EventTrigger> section).

  例如，要获取添加的事件源:

  For example to get the event source you add:

  <ValueQueries>
    <Value name="eventSource">Event/System/Provider/@Name</Value>
  </ValueQueries>
  

  现在删除任务，并通过导入修改后的XML文件重新创建它.

  Now delete the task and recreate it by importing your modified XML file.

  现在，您可以配置任务的操作以运行PowerShell.exe和脚本，然后引用上面用于值查询的任何名称，作为脚本的参数输入.例如:

  You can now configure the Action of the task to run PowerShell.exe and your script and then reference whatever names you used for your valuequeries above as parameter inputs to your script. For example:

  powershell.exe .\TriggerScript.ps1 -eventSource $(eventSource)
  

  当然，您的脚本只需要通过顶部的param()块来支持这些输入，例如:

  Of course then your script just needs to support these inputs via a param() block at the top, e.g:

  param($eventSource)
  

  这篇关于根据事件日志触发Powershell的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！