This object discovery discovers all databases running for a given instance of SQL Server 2008 DB Engine. By default, all databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
This object discovery discovers all databases running for a given instance of SQL Server 2008 DB Engine. By default, all databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
Exclude List: A comma-separated list of database names that should be excluded from discovery. You can use the wildcard * to exclude all databases.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Exclude List | A comma-separated list of database names that should be excluded from discovery. You can use the wildcard * to exclude all databases. |
|
Interval (seconds) | The polling interval in seconds that discovery will run on. | 14400 |
Synchronization Time | Time at which to do initial discovery. |
|
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 300 |
Target | Microsoft.SQLServer.2008.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.DBDiscovery | Default |
<Discovery ID="Microsoft.SQLServer.2008.DatabaseDiscoveryRule" Enabled="true" Target="Microsoft.SQLServer.2008.DBEngine">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2008.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="Microsoft.SQLServer.2008.DBDiscovery">
<IntervalSeconds>14400</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>