last sync: 2021-Jan-15 16:07:21 UTC

Azure Policy definition

Vulnerabilities on your SQL servers on machine should be remediated

Name Vulnerabilities on your SQL servers on machine should be remediated
Azure Portal
Id 6ba6d016-e7c3-4842-b8f2-4992ebc0d72d
Version 1.0.0
details on versioning
Category Security Center
Microsoft docs
Description SQL Vulnerability Assessment scans your database for security vulnerabilities, and exposes any deviations from best practices such as misconfigurations, excessive permissions, and unprotected sensitive data. Resolving the vulnerabilities found can greatly improve your database security posture.
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
2021-01-05 16:06:49 add 6ba6d016-e7c3-4842-b8f2-4992ebc0d72d
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State
Enable Monitoring in Azure Security Center 1f3afdf9-d0c9-4c3d-847f-89da613e70a8 Security Center GA
Json
{
  "properties": {
    "displayName": "Vulnerabilities on your SQL servers on machine should be remediated",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "SQL Vulnerability Assessment scans your database for security vulnerabilities, and exposes any deviations from best practices such as misconfigurations, excessive permissions, and unprotected sensitive data. Resolving the vulnerabilities found can greatly improve your database security posture.",
    "metadata": {
      "version": "1.0.0",
      "category": "Security Center"
    },
    "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",
        "in": [
          "Microsoft.Compute/virtualMachines",
          "Microsoft.HybridCompute/machines"
        ]
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.Security/assessments",
          "name": "f97aa83c-9b63-4f9a-99f6-b22c4398f936",
          "existenceCondition": {
            "field": "Microsoft.Security/assessments/status.code",
            "in": [
              "NotApplicable",
              "Healthy"
            ]
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/6ba6d016-e7c3-4842-b8f2-4992ebc0d72d",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "6ba6d016-e7c3-4842-b8f2-4992ebc0d72d"
}