Home
  •  

Discover SQL 2000 Databases

Microsoft.SQLServer.2000.DatabaseDiscoveryRule (Discovery)

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

Knowledge Base article:

Summary

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

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.SQLServer.2000.DBEngine
EnabledTrue
Frequency1800
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
  • Microsoft.SQLServer.2000.Database
    • DatabaseName
    • RecoveryModel
    • DatabaseAutogrow
    • DatabaseSize
    • DatabaseSizeNumeric
    • LogAutogrow
    • Updateability
    • UserAccess
    • Collation
    • LogSize
    • LogSizeNumeric
    • Owner

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.2000.DatabaseDiscoveryRule" Target="Microsoft.SQLServer.2000.DBEngine" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2000.Database">

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="DatabaseName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="RecoveryModel"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="DatabaseAutogrow"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="DatabaseSize"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="DatabaseSizeNumeric"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="LogAutogrow"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="Updateability"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="UserAccess"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="Collation"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="LogSize"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="LogSizeNumeric"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Database" PropertyID="Owner"/>

    </DiscoveryClass>

  </DiscoveryTypes>

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

    <IntervalSeconds>1800</IntervalSeconds>

    <SyncTime/>

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

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

    <SQLConnectionString>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</SQLConnectionString>

    <SQLInstanceName>$Target/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</SQLInstanceName>

    <ExcludeList/>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>