This discovery rule discovers the file information for each SQL Server 2014 Database.
This discovery rule discovers the file information for each SQL Server 2014 Database
Use overrides for individual instances, or groups to disable discovery for specific databases or DB Engine instances.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 300 |
Target | Microsoft.SQLServer.2014.DBFilesPartitionSeed |
Enabled | True |
Remotable | False |
Discovered Classes and their attribuets: |
---|
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2014.DBFilesDiscovery | Default |
<Discovery ID="Microsoft.SQLServer.2014.Discovery.DBFile.Partitioned" Enabled="true" Target="Microsoft.SQLServer.2014.DBFilesPartitionSeed">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2014.DBFile">
<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/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</NetworkName>
<SQLConnectionString>$Target/Host/Property[Type="Microsoft.SQLServer.2014.DBEngine"]/ConnectionString$</SQLConnectionString>
<SQLInstanceName>$Target/Host/Property[Type="Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</SQLInstanceName>
<TimeoutSeconds>300</TimeoutSeconds>
<FileType>0</FileType>
<PartitionNumber>$Target/Property[Type="Microsoft.SQLServer.2014.DBFilesPartitionSeed"]/PartitionNumber$</PartitionNumber>
<PartitionCount>$Target/Property[Type="Microsoft.SQLServer.2014.DBFilesPartitionSeed"]/PartitionCount$</PartitionCount>
<TcpPort>$Target/Host/Property[Type="Microsoft.SQLServer.2014.DBEngine"]/TcpPort$</TcpPort>
</DataSource>
</Discovery>