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

Configure firewall IP address range checking. This control 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 control targets the following resource types:

Azure > SQL > Server

Primary Policies

The following policies can be used to configure this control:

In Your Workspace

Developers

Control Type URI

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

Category URI

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

GraphQL

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

query controls(filter: "controlTypeId:'tmod:@turbot/azure-sql#/control/types/serverFirewallIpRangesApproved'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-sql#/control/types/serverFirewallIpRangesApproved"