MSSQL on Windows: General Always On Discovery

Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscovery (Discovery)

This discovery is used to define which instances have Always On enabled.

Knowledge Base article:

Summary

This is discovery for Microsoft SQL Server Always On objects including Availability Groups and Availability Replicas on Windows.

Overridable 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.Windows.AlwaysOnSeed
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Core.AvailabilityGroup Microsoft.SQLServer.Core.DistributedAvailabilityGroup Microsoft.SQLServer.Windows.AvailabilityGroupHealth Microsoft.SQLServer.Windows.AvailabilityReplica
Discovered relationships and their attribuets:
Microsoft.SQLServer.Core.AvailabilityGroupContainsAvailabilityReplica Microsoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroup Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Windows.DataSource.GeneralAlwaysOnDiscovery	Default

Source Code:

<Discovery ID="Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscovery" Target="Microsoft.SQLServer.Windows.AlwaysOnSeed" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroup"/>

    <DiscoveryClass TypeID="SqlCoreLib!Microsoft.SQLServer.Core.DistributedAvailabilityGroup"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Windows.AvailabilityGroupHealth"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Windows.AvailabilityReplica"/>

    <DiscoveryRelationship TypeID="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroupContainsAvailabilityReplica"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth"/>

    <DiscoveryRelationship TypeID="SqlCoreLib!Microsoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroup"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.Windows.DataSource.GeneralAlwaysOnDiscovery">

    <MachineName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/MachineName$</MachineName>

    <NetbiosComputerName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/NetbiosComputerName$</NetbiosComputerName>

    <InstanceName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/InstanceName$</InstanceName>

    <ConnectionString>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/ConnectionString$</ConnectionString>

    <InstanceVersion>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>

    <InstanceEdition>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Edition$</InstanceEdition>

    <MonitoringType>$Target/Host/Property[Type="Microsoft.SQLServer.Windows.DBEngine"]/MonitoringType$</MonitoringType>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

  </DataSource>

</Discovery>