Home
  •  

Discover Files

Microsoft.SQLServer.2005.DBFilesDiscoveryRule (Discovery)

This object discovery discovers the file information for each SQL Server 2005 Database. The discovery is disabled by default and should be enabled for specific databases or DB Engine instances where deeper file monitoring is required.

Knowledge Base article:

Summary

This object discovery discovers the file information for each SQL Server 2005 Database. The discovery is disabled by default and should be enabled for specific databases or DB Engine instances where deeper file monitoring is required.

Configuration

Use overrides for individual instances, or groups to enable discovery for specific databases or DB Engine instances.

Element properties:

TargetMicrosoft.SQLServer.2005.DBEngine
EnabledTrue
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2005.DBFilesDiscovery Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2005.DBFilesDiscoveryRule" Enabled="true" Target="Microsoft.SQLServer.2005.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2005.DBFile">

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FileID"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FileName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FilePath"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="Size"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="Drive"/>

    </DiscoveryClass>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2005.DBLogFile">

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FileID"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FileName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="FilePath"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="Size"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBFile" PropertyID="Drive"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2005.DBFilesDiscovery">

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

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

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>