Descobrir SQL Server Agent para um Mecanismo de Banco de Dados

Microsoft.SQLServer.2008.AgentDiscovery (Discovery)

Esta descoberta de objeto descobre o SQL Server Agent para uma instância do Mecanismo de Banco de Dados do SQL Server 2008. Sempre haverá uma instância do SQL Server Agent para cada instância do Mecanismo de Banco de Dados.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

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

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

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

    </DiscoveryClass>

  </DiscoveryTypes>

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

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

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

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2008.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="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</Name>

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

        </Setting>

        <Setting>

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

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

        </Setting>

        <Setting>

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

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

        </Setting>

        <Setting>

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

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

        </Setting>

      </Settings>

    </InstanceSettings>

  </DataSource>

</Discovery>