AzPolicyAdvertizer

last sync: 2020-Jul-03 15:47:34 UTC

Azure Policy

[Deprecated]: Advanced data security settings for SQL server should contain an email address to receive security alerts

Policy DisplayName [Deprecated]: Advanced data security settings for SQL server should contain an email address to receive security alerts
Policy Id 9677b740-f641-4f3c-b9c5-466005c85278
Policy Category SQL
Policy Description Ensure that an email address is provided for the 'Send alerts to' field in the Advanced Data Security server settings. This email address receives alert notifications when anomalous activities are detected on SQL servers.
Policy Mode Indexed
Policy Type BuiltIn
Policy in Preview FALSE
Policy Deprecated True
Policy Effect Default: Disabled
Allowed: (AuditIfNotExists,Disabled)
Roles used none
Policy Changes
Date/Time (UTC ymd) (i) Change Change detail
2020-07-01 14:50:07 change: DisplayName previous DisplayName: Advanced data security settings for SQL server should contain an email address to receive security alerts
Used in Policy Initiative(s) none
Policy Rule 
{
  "properties": {
  "displayName": "[Deprecated]: Advanced data security settings for SQL server should contain an email address to receive security alerts",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "Ensure that an email address is provided for the 'Send alerts to' field in the Advanced Data Security server settings. This email address receives alert notifications when anomalous activities are detected on SQL servers.",
    "metadata": {
      "version": "1.0.0-deprecated",
      "category": "SQL",
      "deprecated": true
    },
    "parameters": {
      "effect": {
        "type": "String",
        "metadata": {
        "displayName": "[Deprecated]: Effect",
          "description": "Enable or disable the execution of the policy"
        },
        "allowedValues": [
          "AuditIfNotExists",
          "Disabled"
        ],
        "defaultValue": "Disabled"
      }
    },
    "policyRule": {
      "if": {
        "field": "type",
        "equals": "Microsoft.Sql/servers"
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.Sql/servers/securityAlertPolicies",
          "name": "default",
          "existenceCondition": {
          "field": "Microsoft.Sql/servers/securityAlertPolicies/emailAddresses[*]",
            "notEquals": ""
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/9677b740-f641-4f3c-b9c5-466005c85278",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "9677b740-f641-4f3c-b9c5-466005c85278"
}