MSSQL 2014: Descobrir SQL Server Agent para um Mecanismo de Banco de Dados

Microsoft.SQLServer.2014.AgentDiscovery (Discovery)

Esta regra de descoberta descobre o SQL Server Agent para uma instância do Mecanismo de Banco de Dados do SQL Server 2014. Pode ter apenas uma instância do SQL Server Agent para cada instância do Mecanismo de Banco de Dados.

Knowledge Base article:

Resumo

Parâmetros Substituíveis

Nome	Descrição	Valor padrão
Habilitado		Sim
Frequência	O intervalo de tempo recorrente em segundos no qual executa-se o fluxo de trabalho.	14400

Element properties:

Target	Microsoft.SQLServer.2014.DBEngine
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2014.Agent ServiceName Account DisplayName

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper	Microsoft.SQLServer.2014.SQLDiscoveryAccount

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.AgentDiscovery" Target="Microsoft.SQLServer.2014.DBEngine" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2014.Agent">

      <Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="ServiceName"/>

      <Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="Account"/>

      <Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="DisplayName"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper" RunAs="Microsoft.SQLServer.2014.SQLDiscoveryAccount">

    <NameSpace>\\$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$\root\Microsoft\SqlServer\ComputerManagement12</NameSpace>

    <Query>SELECT ServiceName, StartName, DisplayName  FROM SqlService WHERE ServiceName="$Target/Property[Type="Microsoft.SQLServer.2014.DBEngine"]/AgentName$"</Query>

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

          <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

          <Value>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</Name>

          <Value>$Target/Property[Type="Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/ServiceName$</Name>

          <Value>$Data/Property[@Name='ServiceName']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/Account$</Name>

          <Value>$Data/Property[@Name='StartName']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/DisplayName$</Name>

          <Value>$Data/Property[@Name='DisplayName']$</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

  </DataSource>

</Discovery>