Policy: Azure > SQL > Elastic Pool > Active > Last Modified
The number of days since the Azure SQL elastic pool was last modified before it is considered inactive.
The Active control determines whether the resource is in active use, and if not, has the ability to delete / cleanup the resource. When running an automated compliance environment, it's common to end up with a wide range of alarms that are difficult and time consuming to clear. The Active control brings automated, well-defined control to this process.
The Active control checks the status of all defined Active policies for the resource (Azure > SQL > Elastic Pool > Active > *
), raises an alarm, and takes the defined enforcement action. Each Active sub-policy can calculate a status of active, inactive or skipped. Generally, if the resource appears to be Active for any reason it will be considered Active.
Note In contrast with Approved, where if the resource appears to be Unapproved for any reason it will be considered Unapproved.
Resource Types
This policy targets the following resource types:
Primary Policy
This policy is used with the following primary policy:
Controls
Policy Specification
Schema Type |
|
---|---|
Default |
|
Valid Values [YAML] |
|
Examples [YAML] |
|
Category
In Your Workspace
Developers
- tmod:@turbot/turbot#/control/categories/resourceActive
- tmod:@turbot/azure-sql#/policy/types/elasticPoolActiveLastModified
- turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/elasticPoolActiveLastModified"
- turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/elasticPoolActiveLastModified"
Get Policy TypeGet Policy Settings