Esta regra de descoberta descobre um destino de coleção de log de evento para uma Replicação do Microsoft SQL Server 2014. Esse objeto é utilizado para coletar erros de módulo de log de eventos de computadores que possuam componentes de Replicação.
Esta regra de descoberta descobre um destino de coleção de log de evento para uma Replicação do Microsoft SQL Server 2014. Esse objeto é utilizado para coletar erros de módulo de log de eventos de computadores que possuam componentes de Replicação.
Nome | Descrição | Valor Padrão |
Habilitado | Habilita ou desabilita o fluxo de trabalho | Sim |
Frequência em segundos | O intervalo de tempo recorrente em segundos no qual executa-se o fluxo de trabalho. | 14400 |
Target | Microsoft.Windows.Computer |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Windows.FilteredRegistryDiscoveryProvider | Microsoft.SQLServer.Replication.Discovery.RunAs.Discovery |
<Discovery ID="Microsoft.SQLServer.2014.Replication.Discovery.EventLogCollectionTargetDiscovery" Enabled="true" Target="Windows!Microsoft.Windows.Computer" ConfirmDelivery="false" Remotable="true" Priority="Normal">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2014.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>SQLServer2014Installed</AttributeName>
<Path>SOFTWARE\Microsoft\Microsoft SQL Server\120\Machines</Path>
<PathType>0</PathType>
<AttributeType>0</AttributeType>
</RegistryAttributeDefinition>
<RegistryAttributeDefinition>
<AttributeName>SQLServer201432Installed</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.2014.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>2014</Value>
</Setting>
</Settings>
</InstanceSettings>
<Expression>
<Or>
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">Values/SQLServer201432Installed</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/SQLServer2014Installed</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>