The object discovery discovers Subscribers of an instance of Microsoft SQL Server 2017 on Windows.
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.
Replication Publishing Model Overview
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 |
Target | Microsoft.SQLServer.2017.Windows.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2017.Replication.Windows.DataSource.SubscriberDiscovery | Microsoft.SQLServer.DiscoveryAccount |
<Discovery ID="Microsoft.SQLServer.2017.Replication.Windows.Discovery.Subscriber" Target="SQL2017WD!Microsoft.SQLServer.2017.Windows.DBEngine" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2017.Replication.Windows.Subscriber"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2017.Replication.Windows.DataSource.SubscriberDiscovery" RunAs="GPMP!Microsoft.SQLServer.DiscoveryAccount">
<MachineName>$Target/Property[Type='SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine']/MachineName$</MachineName>
<InstanceName>$Target/Property[Type='SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine']/InstanceName$</InstanceName>
<ConnectionString>$Target/Property[Type='SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine']/ConnectionString$</ConnectionString>
<MonitoringType>$Target/Property[Type="SQL2017WD!Microsoft.SQLServer.2017.Windows.DBEngine"]/MonitoringType$</MonitoringType>
<ServiceName>$Target/Property[Type='SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine']/ServiceName$</ServiceName>
<AgentServiceName>$Target/Property[Type='SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine']/AgentName$</AgentServiceName>
<IntervalSeconds>14400</IntervalSeconds>
<SyncTime/>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<ClassId>$MPElement[Name='Microsoft.SQLServer.2017.Replication.Windows.Subscriber']$</ClassId>
<InstanceClassId>$MPElement[Name='SQL2017WD!Microsoft.SQLServer.2017.Windows.DBEngine']$</InstanceClassId>
<SubscriberInstanceGroupClassId>$MPElement[Name='MSRL!Microsoft.SQLServer.2017.Replication.Library.SubscriberInstanceGroup']$</SubscriberInstanceGroupClassId>
<SubscriberInstanceGroupContainsInstanceRelationId>$MPElement[Name='MSRL!Microsoft.SQLServer.2017.Replication.Library.SubscriberInstanceGroupContainsInstance']$</SubscriberInstanceGroupContainsInstanceRelationId>
<SubscriberExpressGroupClassId>$MPElement[Name='MSRL!Microsoft.SQLServer.2017.Replication.Library.SubscriberExpressGroup']$</SubscriberExpressGroupClassId>
<SubscriberExpressGroupContainsGenericSubscriberRelationId>$MPElement[Name='MSRL!Microsoft.SQLServer.2017.Replication.Library.SubscriberExpressGroupContainsGenericSubscriber']$</SubscriberExpressGroupContainsGenericSubscriberRelationId>
<TimeoutSeconds>300</TimeoutSeconds>
</DataSource>
</Discovery>