This discovery is used to define which machines have AlwaysOn enabled.
AlwaysOn Seed Discovery
Name | Description | Default Value |
Enabled |
| Yes |
Frequency | The recurring interval of time in seconds in which to run the workflow. | 14400 |
Target | Microsoft.SQLServer.2014.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Windows.FilteredRegistryDiscoveryProvider | Default |
<Discovery ID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscovery" Enabled="true" Target="MicrosoftSQLServer2014Discovery!Microsoft.SQLServer.2014.DBEngine" ConfirmDelivery="false" Remotable="true" Priority="Normal">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.FilteredRegistryDiscoveryProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>
<RegistryAttributeDefinitions>
<RegistryAttributeDefinition>
<AttributeName>IsEnabled</AttributeName>
<Path>SOFTWARE\Microsoft\Microsoft SQL Server\$Target/Property[Type="MicrosoftSQLServer2014Discovery!Microsoft.SQLServer.2014.DBEngine"]/InstanceID$\MSSQLServer\HADR\HADR_Enabled</Path>
<PathType>1</PathType>
<AttributeType>2</AttributeType>
</RegistryAttributeDefinition>
</RegistryAttributeDefinitions>
<Frequency>14400</Frequency>
<ClassId>$MPElement[Name="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed"]$</ClassId>
<InstanceSettings>
<Settings>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed"]/InstanceName$</Name>
<Value>$Target/Property[Type="MicrosoftSQLServer2014Discovery!Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>
<Value>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="System!System.Entity"]/DisplayName$</Name>
<Value>$Target/Property[Type="System!System.Entity"]/DisplayName$ AlwaysOn Seed</Value>
</Setting>
</Settings>
</InstanceSettings>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Values/IsEnabled</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">1</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</DataSource>
</Discovery>