MSSQL 2012 Replication: Subscriber Discovery

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

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

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	Synchronization Time
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.2012.DBEngine
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2012.Replication.Subscriber
Discovered relationships and their attribuets:
Microsoft.SQLServer.2012.Replication.Discovery.SubscriberRefersInstance

Member Modules:

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

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2012.Replication.Discovery.SubscriberRefersInstance"/>

  </DiscoveryTypes>

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

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <SqlTimeout>15</SqlTimeout>

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

    <InstanceName>$Target/Property[Type='MSL!Microsoft.SQLServer.ServerRole']/InstanceName$</InstanceName>

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

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

    <SubscriberInstanceRelationshipId>$MPElement[Name='Microsoft.SQLServer.2012.Replication.Discovery.SubscriberRefersInstance']$</SubscriberInstanceRelationshipId>

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

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

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

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

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

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

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>