Home
  •  

Discover Mirrored Databases for a Database Engine

Microsoft.SQLServer.2016.Mirroring.DatabaseDiscovery (Discovery)

This object discovery discovers all mirrored databases running for a given instance of SQL Server 2016 DB Engine. By default all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or the * character to exclude all databases.

Knowledge Base article:

Summary

This object discovery discovers all mirrored databases running for a given instance of SQL Server 2016 DB Engine. By default all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or the * character to exclude all databases.

Configuration

Exclude List: A comma-separated list of database names that should be excluded from discovery. You can use the wildcard * to exclude all databases.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Exclude List

A comma-separated list of database names that should be excluded from discovery. You can use the wildcard * to exclude all databases.

 

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

Element properties:

TargetMicrosoft.SQLServer.2016.DBEngine
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
Discovered relationships and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.Mirroring.DatabaseDiscoveryProvider Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2016.Mirroring.DatabaseDiscovery" Enabled="true" Target="SQL2016Core!Microsoft.SQLServer.2016.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2016.Mirroring.Database">

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Database" PropertyID="MirroringGUID"/>

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Database" PropertyID="MirroringRole"/>

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Database" PropertyID="Level"/>

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Database" PropertyID="Partner"/>

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Database" PropertyID="Witness"/>

    </DiscoveryClass>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2016.Mirroring.Group">

      <Property TypeID="Microsoft.SQLServer.2016.Mirroring.Group" PropertyID="MirroringGUID"/>

    </DiscoveryClass>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2016.Mirroring.GroupContainsDatabase"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2016.Mirroring.DatabaseDiscoveryProvider">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

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

    <SQLConnectionString>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$</SQLConnectionString>

    <SQLInstanceName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$</SQLInstanceName>

    <ExcludeList/>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>