MSSQL on Windows Replication: Subscriber Discovery

Microsoft.SQLServer.Replication.Windows.Discovery.Subscriber (Discovery)

The object discovery discovers Subscribers of an instance of Microsoft SQL Server on Windows.

Knowledge Base article:

Summary

A Subscriber is a database instance that receives replicated data. A Subscriber can receive data from multiple Publishers and Publications. Depending on the type of replication chosen, the Subscriber can also pass data changes back to the Publisher or republish the data to other Subscribers.

External

Replication Publishing Model Overview

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	14400
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300
Timeout for database connection (seconds)	The workflow will fail and register an event if it cannot access the database during the specified period.	15

Element properties:

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

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Replication.Windows.Subscriber

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Windows.Discovery.Subscriber" Target="SqlDiscW!Microsoft.SQLServer.Windows.DBEngine" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Windows.Subscriber"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.Replication.Windows.DataSource.SubscriberDiscovery" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Discovery">

    <MachineName>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/MachineName$</MachineName>

    <NetbiosComputerName>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/NetbiosComputerName$</NetbiosComputerName>

    <InstanceName>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/InstanceName$</InstanceName>

    <ConnectionString>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/ConnectionString$</ConnectionString>

    <MonitoringType>$Target/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.DBEngine"]/MonitoringType$</MonitoringType>

    <ServiceName>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/ServiceName$</ServiceName>

    <AgentServiceName>$Target/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/AgentName$</AgentServiceName>

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <ClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Windows.Subscriber']$</ClassId>

    <InstanceClassId>$MPElement[Name='SqlDiscW!Microsoft.SQLServer.Windows.DBEngine']$</InstanceClassId>

    <SubscriberInstanceGroupClassId>$MPElement[Name='MSRL!Microsoft.SQLServer.Replication.Core.SubscriberInstanceGroup']$</SubscriberInstanceGroupClassId>

    <SubscriberInstanceGroupContainsInstanceRelationId>$MPElement[Name='MSRL!Microsoft.SQLServer.Replication.Core.SubscriberInstanceGroupContainsInstance']$</SubscriberInstanceGroupContainsInstanceRelationId>

    <SubscriberExpressGroupClassId>$MPElement[Name='MSRL!Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup']$</SubscriberExpressGroupClassId>

    <SubscriberExpressGroupContainsGenericSubscriberRelationId>$MPElement[Name='MSRL!Microsoft.SQLServer.Replication.Core.SubscriberExpressGroupContainsGenericSubscriber']$</SubscriberExpressGroupContainsGenericSubscriberRelationId>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>