Estado de configuración de SPN de SQL 2008

Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatus (UnitMonitorType)

Este tipo de monitor comprueba el estado de una configuración de SPN del motor de base de datos de Microsoft SQL Server 2008.

Element properties:

Show References:
- Unit Monitors (1)

RunAs	Microsoft.SQLServer.SQLProbeAccount
Accessibility	Internal
Support Monitor Recalculate	False

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2008.SPNConfigurationStateProvider	Default
FilterBad	ConditionDetection	System.ExpressionFilter	Default
FilterGood	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
IntervalSeconds	int	$Config/IntervalSeconds$	Intervalo (s)
SyncTime	string	$Config/SyncTime$	Hora de sincronización
TimeoutSeconds	int	$Config/TimeoutSeconds$	Tiempo de espera (s)
SearchScope	string	$Config/SearchScope$	Ámbito de búsqueda	Use la búsqueda LDAP cuando el ámbito de una búsqueda sea el dominio o una unidad organizativa. Cuando el ámbito de una búsqueda sea el bosque, la consulta se puede resolver dentro de cualquier partición mediante una búsqueda en un Catálogo global (GC). Lista de valores: LDAP GC

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatus" Accessibility="Internal" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">

  <MonitorTypeStates>

    <MonitorTypeState ID="Good"/>

    <MonitorTypeState ID="Bad"/>

  </MonitorTypeStates>

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ComputerNetworkName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="NetbiosComputerName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Account" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ServiceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SearchScope" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>

    <OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

    <OverrideableParameter ID="SearchScope" ParameterType="string" Selector="$Config/SearchScope$"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.2008.SPNConfigurationStateProvider" ID="DS">

        <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

        <SyncTime>$Config/SyncTime$</SyncTime>

        <ComputerNetworkName>$Config/ComputerNetworkName$</ComputerNetworkName>

        <NetbiosComputerName>$Config/NetbiosComputerName$</NetbiosComputerName>

        <InstanceName>$Config/InstanceName$</InstanceName>

        <Account>$Config/Account$</Account>

        <ServiceName>$Config/ServiceName$</ServiceName>

        <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

        <SearchScope>$Config/SearchScope$</SearchScope>

      </DataSource>

      <ConditionDetection ID="FilterGood" TypeID="System!System.ExpressionFilter">

        <Expression>

          <Not>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='HasIssue']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">True</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </Not>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="FilterBad" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">Property[@Name='HasIssue']</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">True</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="Good">

        <Node ID="FilterGood">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="Bad">

        <Node ID="FilterBad">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>