Policy: Azure > SQL > Database > Regions

A list of Azure regions in which Azure SQL databases are supported for use.

Any databases in a region not listed here will not be recorded in CMDB.

The expected format is an array of regions names. You may use the '*' and '?' wildcard characters.

Targets

This policy targets the following resource types:

Azure > Subscription

Controls

Setting this policy configures these controls:

Policy Specification

Default template	`{% if $.regions.value \| length == 0 %} [] {% endif %}{% for item in $.regions.value %}- '{{ item }}' {% endfor %}`
Default template input	`\| { regions: policyValue(uri:"tmod:@turbot/azure-sql#/policy/types/sqlRegionsDefault") { value } }`

Default template

{% if $.regions.value | length == 0 %} [] {% endif %}{% for item in $.regions.value %}- '{{ item }}'
{% endfor %}

Default template input

|
  {
    regions: policyValue(uri:"tmod:@turbot/azure-sql#/policy/types/sqlRegionsDefault") {
      value
    }
  }

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/cloudLocation

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/databaseRegions

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/databaseRegions") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseRegions'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseRegions'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/databaseRegions"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/databaseRegions"