Policy: Azure > SQL Virtual Machine Service > SQL Virtual Machine > Approved > Regions

A list of Azure regions in which Azure SQL Virtual Machine Service sql virtual machines are approved for use.

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

This policy will be evaluated by the Approved control. If an Azure SQL Virtual Machine Service sql virtual machine is created in a region that is not in the approved list, it will be subject to the action specified in the Azure > SQL Virtual Machine Service > SQL Virtual Machine > Approved policy.

See Approved for more information.

Resource Types

This policy targets the following resource types:

Azure > SQL Virtual Machine Service > SQL Virtual Machine

Primary Policy

This policy is used with the following primary policy:

Azure > SQL Virtual Machine Service > SQL Virtual Machine > Approved

Controls

Azure > SQL Virtual Machine Service > SQL Virtual Machine > Approved

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-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceApprovedRegionsDefault") { 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-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceApprovedRegionsDefault") {
      value
    }
  }

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineApprovedRegions

GraphQL

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

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

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

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineApprovedRegions"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineApprovedRegions"