MSSQL 2014: Arquivo de Log de Transação da Descoberta

Microsoft.SQLServer.2014.Discovery.DBLogFile (Discovery)

Esta regra de descoberta descobre todos os arquivos de log de transação para cada Banco de Dados do SQL Server 2014.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.Discovery.DBLogFile" Enabled="true" Target="Microsoft.SQLServer.2014.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

      <Property TypeID="Microsoft.SQLServer.2014.File" PropertyID="FileID"/>

      <Property TypeID="Microsoft.SQLServer.2014.File" PropertyID="FileName"/>

      <Property TypeID="Microsoft.SQLServer.2014.File" PropertyID="FilePath"/>

      <Property TypeID="Microsoft.SQLServer.2014.File" PropertyID="Storage"/>

      <Property TypeID="Microsoft.SQLServer.2014.File" PropertyID="StorageType"/>

    </DiscoveryClass>

  </DiscoveryTypes>

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

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

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

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>