AzPolicyAdvertizer

last sync: 2021-Sep-24 16:09:49 UTC

Azure Policy definition

SQL Server should use a virtual network service endpoint

Name SQL Server should use a virtual network service endpoint
Azure Portal
Id ae5d2f14-d830-42b6-9899-df6cfe9c71a3
Version 1.0.0
details on versioning
Category Network
Microsoft docs
Description This policy audits any SQL Server not configured to use a virtual network service endpoint.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2019-10-11 00:02:54 add ae5d2f14-d830-42b6-9899-df6cfe9c71a3
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State
[Deprecated]: Azure Security Benchmark v1 42a694ed-f65e-42b2-aa9e-8052e9740a92 Regulatory Compliance Deprecated
HITRUST/HIPAA a169a624-5599-4385-a696-c8d643089fab Regulatory Compliance GA
JSON 
{
  "displayName": "SQL Server should use a virtual network service endpoint",
  "policyType": "BuiltIn",
  "mode": "Indexed",
  "description": "This policy audits any SQL Server not configured to use a virtual network service endpoint.",
  "metadata": {
    "version": "1.0.0",
    "category": "Network"
  },
  "parameters": {
    "effect": {
      "type": "String",
      "metadata": {
        "displayName": "Effect",
        "description": "Enable or disable the execution of the policy"
      },
      "allowedValues": [
        "AuditIfNotExists",
        "Disabled"
      ],
      "defaultValue": "AuditIfNotExists"
    }
  },
  "policyRule": {
    "if": {
      "field": "type",
      "equals": "Microsoft.Sql/servers"
    },
    "then": {
      "effect": "[parameters('effect')]",
      "details": {
        "type": "Microsoft.Sql/servers/virtualNetworkRules",
        "existenceCondition": {
          "field": "Microsoft.Sql/servers/virtualNetworkRules/virtualNetworkSubnetId",
          "exists": "true"
        }
      }
    }
  }
}