Home
  •  

Discover SQL 2000 Database Engines (Windows Server)

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

Discovers all instances of SQL 2000 Database Engine on a Windows server. An override can be applied to exclude specified instances if required.

Knowledge Base article:

Summary

This object discovery discovers all instances of SQL Server 2000 DB Engine running on Windows Servers. By default all instances are discovered and monitored. You can override the discovery to exclude one or more instances from being discovered using the Exclude List. This list takes a comma separated list of instance names or the * character to exclude all instances.

Configuration

Exclude List: A comma separated list of database instances that should be excluded from discovery. You can use the wildcard * to exclude all instances.

Element properties:

TargetMicrosoft.Windows.Server.Computer
EnabledTrue
Frequency21600
RemotableFalse

Object Discovery Details:

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

Member Modules:

ID Module Type TypeId RunAs 
DiscoveryDataSource DataSource Microsoft.SQLServer.2000.DBEngineDiscovery Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2000.DBEngineDiscoveryRule.Server" Target="Windows!Microsoft.Windows.Server.Computer" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2000.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="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="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"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DiscoveryDataSource" TypeID="Microsoft.SQLServer.2000.DBEngineDiscovery">

    <IntervalSeconds>21600</IntervalSeconds>

    <SyncTime/>

    <ComputerID>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerID>

    <ComputerName>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <ComputerNETBIOSName>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/NetbiosComputerName$</ComputerNETBIOSName>

    <IsVirtualNode>$Target/Property[Type="Windows!Microsoft.Windows.Server.Computer"]/IsVirtualNode$</IsVirtualNode>

    <ExcludeList/>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>