This rule discovers all databases running on Azure SQL Managed Instance.
This rule discovers all databases running on Azure SQL Managed Instance.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 14400 |
Synchronization Time | Synchronization Time |
|
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 300 |
Timeout for database connection (seconds) | The workflow will fail and register an event, if it cannot access the database during the specified period. | 15 |
Exclude List | A comma-separated list of databases that must be excluded from discovery. Use a wildcard character * to exclude all databases. Otherwise, use conditions like *_test to exclude database names that end with _test, Test* to exclude database names that start with Test, or *test* condition to exclude database names that have test in any place. |
|
Target | Microsoft.Azure.ManagedInstance.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Azure.ManagedInstance.DataSource.DatabaseDiscovery | Default |
<Discovery ID="Microsoft.Azure.ManagedInstance.Discovery.Database" Target="Microsoft.Azure.ManagedInstance.DBEngine" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.Azure.ManagedInstance.Database"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.Azure.ManagedInstance.DataSource.DatabaseDiscovery">
<InstanceName>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/InstanceName$</InstanceName>
<Tier>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/Tier$</Tier>
<HardwareGeneration>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/HardwareGeneration$</HardwareGeneration>
<ReadScaleOutReplicaType>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/ReadScaleOutReplicaType$</ReadScaleOutReplicaType>
<ConnectionString>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/ConnectionString$</ConnectionString>
<AuthType>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/AuthType$</AuthType>
<AuthorityDetails>$Target/Property[Type="Microsoft.Azure.ManagedInstance.DBEngine"]/AuthorityDetails$</AuthorityDetails>
<ExcludeList/>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<IntervalSeconds>14400</IntervalSeconds>
<SyncTime/>
</DataSource>
</Discovery>