MSSQL no Windows: origem de descoberta de mecanismos de banco de dados local do SQL Server

Microsoft.SQLServer.Windows.DataSource.LocalDBEngineDiscovery (DataSourceModuleType)

Este tipo de módulo é usado para descobrir instâncias de Mecanismos de DB do MSSQL local. O módulo consulta o registro e a WMI para obter informações sobre a instalação e, em seguida, conecta-se a cada instância de Mecanismos de DB para coletar informações de propriedade sobre a instância.

Element properties:

Show References:
- Discoveries (1)

Type	DataSourceModuleType
Isolation	Any
Accessibility	Internal
RunAs	Microsoft.SQLServer.Core.RunAs.Discovery
OutputType	System.Discovery.Data

Member Modules:

ID	Module Type	TypeId	RunAs
Scheduler	DataSource	System.Discovery.Scheduler	Default
Probe	ProbeAction	Microsoft.SQLServer.Windows.ProbeAction.LocalDBEngineDiscovery	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
IntervalSeconds	int	$Config/IntervalSeconds$	Intervalo (segundos)	O intervalo de tempo recorrente em segundos no qual executar o fluxo de trabalho.
SyncTime	string	$Config/SyncTime$	Tempo de Sincronização	O tempo de sincronização especificado usando um formato de 24 horas. Pode ser omitido.
TimeoutSeconds	int	$Config/TimeoutSeconds$	Tempo Limite (em segundos)	Especifica o tempo que o fluxo de trabalho pode para ser executado antes de ser fechado e marcado como falha.
AgentlessMonitoring	string	$Config/AgentlessMonitoring$	Monitoramento misto	Especifica os nomes das instâncias que devem ser monitoradas no modo misto. Use vírgulas para dividir nomes de instância. Instâncias de cluster sempre são monitoradas no modo misto. Use "*" para monitorar todos os mecanismos de banco de dados local no modo misto
ExcludeList	string	$Config/ExcludeList$
ExcludedVersions	string	$Config/ExcludedVersions$
ExcludedEditions	string	$Config/ExcludedEditions$

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.Windows.DataSource.LocalDBEngineDiscovery" Accessibility="Internal" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Discovery">

  <Configuration>

    <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:integer"/>

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

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

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

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

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ExcludedEditions" 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="AgentlessMonitoring" ParameterType="string" Selector="$Config/AgentlessMonitoring$"/>

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

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

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource ID="Scheduler" TypeID="System!System.Discovery.Scheduler">

          <Scheduler>

            <SimpleReccuringSchedule>

              <Interval Unit="Seconds">$Config/IntervalSeconds$</Interval>

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

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ProbeAction ID="Probe" TypeID="Microsoft.SQLServer.Windows.ProbeAction.LocalDBEngineDiscovery">

          <DiscoverySourceObjectId>$MPElement$</DiscoverySourceObjectId>

          <DiscoverySourceManagedEntityId>$Target/Id$</DiscoverySourceManagedEntityId>

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

          <PrincipalName>$Config/PrincipalName$</PrincipalName>

          <DBEngineClassId>$MPElement[Name='Microsoft.SQLServer.Windows.LocalDBEngine']$</DBEngineClassId>

          <SQLMonitoringPoolClassId>$MPElement[Name='SqlCoreLib!Microsoft.SQLServer.Core.SQLMonitoringPool']$</SQLMonitoringPoolClassId>

          <ManagementActionPointShouldManageEntityRelationshipId>$MPElement[Name='SC!Microsoft.SystemCenter.ManagementActionPointShouldManageEntity']$</ManagementActionPointShouldManageEntityRelationshipId>

          <ServerComputerClassId>$MPElement[Name='Windows!Microsoft.Windows.Server.Computer']$</ServerComputerClassId>

          <ServerComputerContainsDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Windows.ServerComputerContainsDBEngine']$</ServerComputerContainsDBEngineRelationshipId>

          <HealthServiceClassId>$MPElement[Name='SC!Microsoft.SystemCenter.HealthService']$</HealthServiceClassId>

          <HealthServiceShouldManageEntityRelationshipId>$MPElement[Name='SC!Microsoft.SystemCenter.HealthServiceShouldManageEntity']$</HealthServiceShouldManageEntityRelationshipId>

          <LocalClusteredDbEngineSeedClassId>$MPElement[Name='Microsoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeed']$</LocalClusteredDbEngineSeedClassId>

          <ResourcePoolGroupId>$MPElement[Name='Microsoft.SQLServer.Windows.ResourcePoolGroup']$</ResourcePoolGroupId>

          <ComputersContainsWindowsComputerRelationshipId>$MPElement[Name='Microsoft.SQLServer.Windows.ComputersGroupContainsWindowsComputer']$</ComputersContainsWindowsComputerRelationshipId>

          <ComputersGroupClassId>$MPElement[Name='Microsoft.SQLServer.Windows.ComputersGroup']$</ComputersGroupClassId>

          <WindowsComputerClassId>$MPElement[Name="Windows!Microsoft.Windows.Computer"]$</WindowsComputerClassId>

          <InMemoryOltpFeatureGroupClassId>$MPElement[Name="Microsoft.SQLServer.Windows.Discovery.InMemoryOltpFeatureGroup"]$</InMemoryOltpFeatureGroupClassId>

          <SmartAdminFeatureGroupClassId>$MPElement[Name="Microsoft.SQLServer.Windows.Discovery.SmartAdminFeatureGroup"]$</SmartAdminFeatureGroupClassId>

          <SqlAgentFeatureGroupClassId>$MPElement[Name="Microsoft.SQLServer.Windows.Discovery.SqlAgentFeatureGroup"]$</SqlAgentFeatureGroupClassId>

          <SqlResurcePoolFeatureGroupClassId>$MPElement[Name="Microsoft.SQLServer.Windows.Discovery.SqlResurcePoolFeatureGroup"]$</SqlResurcePoolFeatureGroupClassId>

          <SqlFeatureGroupContainsDBEngineRelationshipId>$MPElement[Name="Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroupContainsDBEngine"]$</SqlFeatureGroupContainsDBEngineRelationshipId>

          <Publisher>SQLDiscoveryWindows</Publisher>

          <ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>

          <AgentlessMonitoring>$Config/AgentlessMonitoring$</AgentlessMonitoring>

          <ExcludeList>$Config/ExcludeList$</ExcludeList>

          <ExcludedVersions>$Config/ExcludedVersions$</ExcludedVersions>

          <ExcludedEditions>$Config/ExcludedEditions$</ExcludedEditions>

        </ProbeAction>

      </MemberModules>

      <Composition>

        <Node ID="Probe">

          <Node ID="Scheduler"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>System!System.Discovery.Data</OutputType>

</DataSourceModuleType>