Discover Replication Components

Microsoft.SQLServer.2008.ReplicationComponentDiscoveryRule (Discovery)

Consente di individuare tutti i componenti di replica di SQL Server in un motore di database di SQL Server 2008. The discovery is disabled by default.

Knowledge Base article:

Riepilogo

This object discovery discovers all SQL Server Replication components on a SQL Server 2008 DB Engine. The discovery is disabled by default.

Configurazione

Use overrides to enable discovery for individual instances, or groups.

Element properties:

Target	Microsoft.SQLServer.2008.DBEngine
Enabled	False
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2008.Distributor DistributionServer DistributionDB Directory Account DistributionDBInstalled IsDistributionPublisher HasRemoteDistributionPublisher Microsoft.SQLServer.2008.Publisher Name DistributionDB PublisherType DataSource WorkingDirectory

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2008.ReplicationComponentDiscovery	Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2008.ReplicationComponentDiscoveryRule" Enabled="false" Target="Microsoft.SQLServer.2008.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="DistributionServer"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="DistributionDB"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="Directory"/>

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

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="DistributionDBInstalled"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="IsDistributionPublisher"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Distributor" PropertyID="HasRemoteDistributionPublisher"/>

    </DiscoveryClass>

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

      <Property TypeID="SQL!Microsoft.SQLServer.Publisher" PropertyID="Name"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Publisher" PropertyID="DistributionDB"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Publisher" PropertyID="PublisherType"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Publisher" PropertyID="DataSource"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Publisher" PropertyID="WorkingDirectory"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.ReplicationComponentDiscovery">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

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

    <SQLConnectionString>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</SQLConnectionString>

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>