Replicación de Microsoft SQL Server 2008: Detección del destino de recopilación de registros de eventos

Microsoft.SQLServer.2008.Replication.Discovery.EventLogCollectionTargetDiscovery (Discovery)

Esta regla de detección descubre un destino de recopilación de registros de eventos para una replicación de Microsoft SQL Server 2008. Este objeto se utiliza para recopilar errores de módulo del registro de eventos de equipos que disponen de componentes de replicación.

Knowledge Base article:

Resumen

Parámetros invalidables

Nombre	Descripción	Valor predeterminado
Habilitado	Habilita o deshabilita el flujo de trabajo	Sí
Frecuencia en segundos	Intervalo de tiempo periódico en segundos en que se ejecuta el flujo de trabajo.	14400

Element properties:

Target	Microsoft.Windows.Computer
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2008.Replication.EventLogCollectionTarget

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.FilteredRegistryDiscoveryProvider	Microsoft.SQLServer.Replication.Discovery.RunAs.Discovery

Source Code:

<Discovery ID="Microsoft.SQLServer.2008.Replication.Discovery.EventLogCollectionTargetDiscovery" Enabled="true" Target="Windows!Microsoft.Windows.Computer" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2008.Replication.EventLogCollectionTarget"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.FilteredRegistryDiscoveryProvider" RunAs="MSRL!Microsoft.SQLServer.Replication.Discovery.RunAs.Discovery">

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

    <RegistryAttributeDefinitions>

      <RegistryAttributeDefinition>

        <AttributeName>SQLServer2008Installed</AttributeName>

        <Path>SOFTWARE\Microsoft\Microsoft SQL Server\120\Machines</Path>

        <PathType>0</PathType>

        <AttributeType>0</AttributeType>

      </RegistryAttributeDefinition>

      <RegistryAttributeDefinition>

        <AttributeName>SQLServer200832Installed</AttributeName>

        <Path>SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\120\Machines</Path>

        <PathType>0</PathType>

        <AttributeType>0</AttributeType>

      </RegistryAttributeDefinition>

      <RegistryAttributeDefinition>

        <AttributeName>RealComputerName</AttributeName>

        <Path>SYSTEM\CurrentControlSet\Control\ComputerName\ActiveComputerName\ComputerName</Path>

        <PathType>1</PathType>

        <AttributeType>1</AttributeType>

      </RegistryAttributeDefinition>

    </RegistryAttributeDefinitions>

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2008.Replication.EventLogCollectionTarget"]$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

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

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

        </Setting>

        <Setting>

          <Name>$MPElement[Name="System!System.Entity"]/DisplayName$</Name>

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

        </Setting>

        <Setting>

          <Name>$MPElement[Name="MSRL!Microsoft.SQLServer.Replication.Library.GenericEventLogCollectionTarget"]/SQLInstanceVersion$</Name>

          <Value>2008</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

    <Expression>

      <Or>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Values/SQLServer200832Installed</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">true</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Values/RealComputerName</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Values/SQLServer2008Installed</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">true</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Values/RealComputerName</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </Or>

    </Expression>

  </DataSource>

</Discovery>