AzPolicyAdvertizer

last sync: 2021-Sep-22 19:36:51 UTC

Azure Policy definition

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

Name [Deprecated]: Advanced data security settings for SQL server should contain an email address to receive security alerts
Azure Portal
Id 9677b740-f641-4f3c-b9c5-466005c85278
Version 1.0.0-deprecated
details on versioning
Category SQL
Microsoft docs
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.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated True
Effect Default: Disabled
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2020-07-01 14:50:07 change Previous DisplayName: Advanced data security settings for SQL server should contain an email address to receive security alerts
Used in Initiatives none
JSON 
{
  "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": "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": ""
        }
      }
    }
  }
}