MSSQL unter Windows: Lokale SQL Server-Datenbankmodule – Datenquelle für Ermittlung
Microsoft.SQLServer.Windows.DataSource.LocalDBEngineDiscovery (DataSourceModuleType)
Dieser Modultyp wird zur Ermittlung von lokalen MSSQL-Datenbankmodulinstanzen verwendet. Das Modul fragt die Registrierung und WMI nach Installationsinformationen ab und stellt dann eine Verbindung mit jeder gefundenen Instanz der Datenbankmodule her, um Informationen über die Instanz zu sammeln.
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"/>
</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$"/>
</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>
</ProbeAction>
</MemberModules>
<Composition>
<Node ID="Probe">
<Node ID="Scheduler"/>
</Node>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>System!System.Discovery.Data</OutputType>
</DataSourceModuleType>