MSSQL: 제네릭 복제 데이터베이스 상태 검색

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

이 개체 검색은 게시된 데이터베이스와 관련된 개체에 대한 집계 상태 컨테이너 및 관계를 검색합니다.

Knowledge Base article:

요약

이 개체 검색은 게시된 데이터베이스와 관련된 개체에 대한 집계 상태 컨테이너 및 관계를 검색합니다.

재정의 가능한 매개 변수

이름	설명	기본값
사용	워크플로 사용하거나 사용하지 않도록 설정합니다.	예
간격(초)	워크플로를 실행하는 반복 시간 간격(초)입니다.	14400
동기화 시간	동기화 시간
시간 제한(초)	시간 제한(초)	15
시간 제한(초)	닫히고 실패한 것으로 표시되기 전에 워크플로를 실행할 수 있는 시간을 지정합니다.	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>