MSSQL sur Windows : Source de découverte des instances locales de moteur de base de données SQL Server
Microsoft.SQLServer.Windows.DataSource.LocalDBEngineDiscovery (DataSourceModuleType)
Ce type de module permet de découvrir les instances locales de moteur de base de données MSSQL. Le module interroge le Registre et WMI sur les informations d'installation, puis se connecte à chaque instance de moteur de base de données détectée pour collecter les informations sur les propriétés de l'instance.
Element properties: Member Modules:
Overrideable Parameters:
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>