Policy: Azure > SQL > Server > Firewall > IP Ranges > Approved

Configure firewall IP address range checking. This policy defines whether to verify the firewall IP address ranges are approved, as well as the subsequent action to take on unapproved items. Rules for all Approved policies will be compiled in Approved > Compiled Rules and then evaluated.

If set to Enforce: Delete unapproved, any unapproved IP address ranges will be deleted from the firewall.

Resource Types

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Firewall > IP Ranges

Controls

Policy Specification

Schema Type	`string`
Default	`Skip`
Valid Values [YAML]	`Skip` `Check: Approved` `Enforce: Delete unapproved`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

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

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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