Discover SQL Server 2012 Database (Windows Server) by Veritas

Veritas.SQLServer.2012.DatabaseDiscoveryRule (Discovery)

This object discovery discovers all databases of SQL Server 2012 DB on Windows Servers. By default all instances are discovered and monitored. You can override the discovery to exclude one or 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.

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Veritas.SQLServer.2012.DatabaseDiscoveryRule" Enabled="true" Target="MSSQL2012Discovery!Microsoft.SQLServer.2012.DBEngine" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="MSSQL2012Discovery!Microsoft.SQLServer.2012.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="DS" TypeID="Veritas.SQLServer.2012.DBDiscovery">

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