Home
  •  

Discover SQL 2005 Database Engines (Windows Server) by Symantec

Symantec.SQLServer.2005.DBEngineDiscoveryRule.Server (Discovery)

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

Knowledge Base article:

Summary

This object discovery discovers all instances of SQL Server 2005 DB Engine running on Windows Servers. By default all instances are discovered and monitored. You can override the discovery to exclude one ore 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 wilcard * to exclude all instances.

Element properties:

TargetMicrosoft.Windows.Server.Computer
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
  • Microsoft.SQLServer.2005.DBEngine
    • InstanceName
    • ConnectionString
    • ServiceName
    • FullTextSearchServiceName
    • 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 
DS DataSource Symantec.SQLServer.2005.DBEngineDiscovery Default

Source Code:

<Discovery ID="Symantec.SQLServer.2005.DBEngineDiscoveryRule.Server" Enabled="true" Target="Windows!Microsoft.Windows.Server.Computer" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="SQL2005Core!Microsoft.SQLServer.2005.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="FullTextSearchServiceName"/>

      <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="DS" TypeID="Symantec.SQLServer.2005.DBEngineDiscovery">

    <IntervalSeconds>14400</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>

    <ExcludeList/>

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>