探索 SQL Server 2012 資料庫引擎 (Windows Server)

Microsoft.SQLServer.2012.DBEngineDiscoveryRule.Server (Discovery)

此物件探索會探索 Windows Server 上執行的所有 SQL Server 2012 資料庫引擎執行個體。根據預設,系統會探索並監視所有的執行個體。您可以使用排除清單來覆寫探索,以排除一個或多個不要探索的執行個體。此清單根據以逗號分隔的執行個體名稱清單或 * 字元來排除所有的執行個體。

Knowledge Base article:

摘要

此物件探索會探索 Windows Server 上執行的所有 SQL Server 2012 資料庫引擎執行個體。根據預設,系統會探索並監視所有的執行個體。您可以使用排除清單來覆寫探索,以排除一個或多個不要探索的執行個體。此清單根據以逗號分隔的執行個體名稱清單或 * 字元來排除所有的執行個體。

組態

排除清單:要從探索中排除的資料庫執行個體清單 (以逗號分隔)。您可以使用萬用字元 * 來排除所有執行個體。

Element properties:

TargetMicrosoft.SQLServer.2012.Seed
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
  • Microsoft.SQLServer.2012.DBEngine
    • InstanceName
    • ConnectionString
    • ServiceName
    • ServiceClusterName
    • FullTextSearchServiceName
    • FullTextSearchServiceClusterName
    • Version
    • Edition
    • AuthenticationMode
    • AgentName
    • AgentClusterName
    • MasterDatabaseLocation
    • MasterDatabaseLogLocation
    • ErrorLogLocation
    • Language
    • ServicePackVersion
    • AuditLevel
    • InstallPath
    • ToolsPath
    • EnableErrorReporting
    • ReplicationWorkingDirectory
    • ReplicationDistributionDatabase
    • PerformanceCounterObject
    • Cluster
    • Account
    • InstanceID

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2012.DBEngineDiscovery Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2012.DBEngineDiscoveryRule.Server" Enabled="true" Target="Microsoft.SQLServer.2012.Seed">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2012.DBEngine">
<Property TypeID="SQL!Microsoft.SQLServer.ServerRole" PropertyID="InstanceName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ConnectionString"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ServiceName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ServiceClusterName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="FullTextSearchServiceName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="FullTextSearchServiceClusterName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Version"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Edition"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AuthenticationMode"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AgentName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AgentClusterName"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="MasterDatabaseLocation"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="MasterDatabaseLogLocation"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ErrorLogLocation"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Language"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ServicePackVersion"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AuditLevel"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="InstallPath"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ToolsPath"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="EnableErrorReporting"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ReplicationWorkingDirectory"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ReplicationDistributionDatabase"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="PerformanceCounterObject"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Cluster"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Account"/>
<Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="InstanceID"/>
</DiscoveryClass>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2012.DBEngineDiscovery">
<IntervalSeconds>14400</IntervalSeconds>
<SyncTime/>
<ComputerID>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerID>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<ComputerNETBIOSName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetbiosComputerName$</ComputerNETBIOSName>
<ExcludeList/>
<IsVirtualNode>$Target/Host/Property[Type="Windows!Microsoft.Windows.Server.Computer"]/IsVirtualNode$</IsVirtualNode>
<TimeoutSeconds>300</TimeoutSeconds>
</DataSource>
</Discovery>