MSSQL 2014: detección de valor de inicialización de AlwaysOn

Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscovery (Discovery)

Esta detección se usa para definir qué máquinas tienen AlwaysOn habilitado.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<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>