Home
  •  

Individuazione di file

Microsoft.SQLServer.2008.DBFilesDiscoveryRule (Discovery)

Consente di individuare le informazioni sui file per ciascun database di SQL Server 2008. 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:

Riepilogo

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

Configurazione

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

Element properties:

TargetMicrosoft.SQLServer.2008.DBEngine
EnabledTrue
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

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

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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