MSSQL: Generic Replication Database Health Discovery

Microsoft.SQLServer.Replication.Core.Discovery.DatabaseHealth (Discovery)

The object discovery discovers the aggregate health containers and relationships for objects related to a published database.

Knowledge Base article:

Summary

The object discovery discovers the aggregate health containers and relationships for objects related to a published database.

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)	Timeout (seconds)	15
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300

Element properties:

Target	Microsoft.SQLServer.Replication.Core.Seed
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Replication.Core.DatabaseHealth Microsoft.SQLServer.Replication.Core.VirtualDistributor Microsoft.SQLServer.Replication.Core.VirtualPublicationHost Microsoft.SQLServer.Replication.Core.VirtualPublisher Microsoft.SQLServer.Replication.Core.VirtualSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost Microsoft.SQLServer.Replication.Core.VirtualSubscription
Discovered relationships and their attribuets:
Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualDistributor Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualPublisher Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualSubscriberHost Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualPublisherHostsVirtualPublicationHost Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualSubscriberHostHostsVirtualSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Replication.Core.DataSource.DatabaseHealthDiscovery	Microsoft.SQLServer.Core.RunAs.SDK

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Core.Discovery.DatabaseHealth" Target="Microsoft.SQLServer.Replication.Core.Seed" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealth"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisher"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublicationHost"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributor"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriber"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscription"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualPublisher"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualDistributor"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualSubscriberHost"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherHostsVirtualPublicationHost"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberHostHostsVirtualSubscriber"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.Replication.Core.DataSource.DatabaseHealthDiscovery" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.SDK">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <MachineName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.Seed']/MachineName$</MachineName>

    <NetbiosComputerName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.Seed']/NetbiosComputerName$</NetbiosComputerName>

    <InstanceName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.Seed']/InstanceName$</InstanceName>

    <ConnectionString>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.Seed']/ConnectionString$</ConnectionString>

    <ClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.DatabaseHealth']$</ClassId>

    <VirtualPublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisher']$</VirtualPublisherClassId>

    <PublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericPublisher']$</PublisherClassId>

    <VirtualPublisherPublisherRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher']$</VirtualPublisherPublisherRelationshipId>

    <VirtualPublisherDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity']$</VirtualPublisherDBEngineRelationshipId>

    <VirtualPublisherDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase']$</VirtualPublisherDatabaseRelationshipId>

    <VirtualPublicationHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublicationHost']$</VirtualPublicationHostClassId>

    <PublicationClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericPublication']$</PublicationClassId>

    <VirtualPublicationHostPublicationRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication']$</VirtualPublicationHostPublicationRelationshipId>

    <VirtualDistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributor']$</VirtualDistributorClassId>

    <VirtualDistributorDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase']$</VirtualDistributorDatabaseRelationshipId>

    <VirtualDistributorDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity']$</VirtualDistributorDBEngineRelationshipId>

    <DistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericDistributor']$</DistributorClassId>

    <VirtualDistributorDistributorRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor']$</VirtualDistributorDistributorRelationshipId>

    <VirtualSubscriberHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost']$</VirtualSubscriberHostClassId>

    <VirtualSubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriber']$</VirtualSubscriberClassId>

    <SubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericSubscriber']$</SubscriberClassId>

    <VirtualSubscriberSubscriberRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber']$</VirtualSubscriberSubscriberRelationshipId>

    <VirtualSubscriberDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity']$</VirtualSubscriberDBEngineRelationshipId>

    <VirtualSubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscription']$</VirtualSubscriptionClassId>

    <SubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericSubscription']$</SubscriptionClassId>

    <VirtualSubscriptionSubscriptionRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription']$</VirtualSubscriptionSubscriptionRelationshipId>

    <VirtualSubscriptionDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase']$</VirtualSubscriptionDatabaseRelationshipId>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>