GCP Security Command Center - Detect DNSSEC disabled for DNS zones

GoogleCloudSCC
| where tostring(Findings.state) == "ACTIVE"
| extend FindingsJson = parse_json(Findings)
| extend FindingCategory = tostring(FindingsJson.category)
| where FindingCategory == "DNSSEC_DISABLED"
| extend ResourceName = tostring(FindingsJson.resourceName)
| extend
  ResourceType = tostring(FindingsResource.type),
  ExternalUri = tostring(FindingsJson.externalUri),
  SourceProps = parse_json(tostring(FindingsJson.sourceProperties)),
  GcpResource = parse_json(tostring(FindingsJson.resource))
// Extract project and managed zone from resourceName like //dns.googleapis.com/projects/PROJECT/managedZones/ZONE
| extend ProjectName = extract(@"projects/([^/]+)", 1, ResourceName)
| extend ManagedZone = extract(@"managedZones/([^/]+)", 1, ResourceName)
| extend Severity = tostring(FindingsJson.severity)
| summarize
  TimeGenerated = max(TimeGenerated)
  by ProjectName, ManagedZone, ResourceType, ResourceName, Severity, ExternalUri

tags:
- CIS GCP Foundation 3.0 3.3
- NIST 800-53 R5 AC-18, CM-2, CM-6, CM-7, CM-9
- PCI-DSS v4.0 1.1.1, 1.2.1, 1.2.6, 1.2.7, 1.4.2, 1.5.1, 2.1.1, 2.2.1
- ISO-27001 v2022 A.8.9
- Cloud Controls Matrix 4 IVS-04
- NIST Cybersecurity Framework 1.0 PR-IP-1
- SOC2 v2017 CC5.2.2
- CIS Controls 8.0 4.2
version: 1.0.0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Google%20Cloud%20Platform%20Security%20Command%20Center/Analytic%20Rules/GCPDNSSECDisabled.yaml
triggerThreshold: 0
requiredDataConnectors:
- dataTypes:
  - GoogleCloudSCC
  connectorId: GoogleSCCDefinition
tactics:
- Collection
- CommandAndControl
- DefenseEvasion
relevantTechniques:
- T1557
- T1071.004
- T1562.001
kind: Scheduled
alertDetailsOverride:
  alertDescriptionFormat: DNSSEC is disabled for managed zone {{ManagedZone}} in project {{ProjectName}}. Review the zone configuration and enable DNSSEC where appropriate.
  alertDisplayNameFormat: GCP DNS zone {{ManagedZone}} has DNSSEC disabled
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: ResourceName
  entityType: CloudApplication
description: |
  Detects Google Cloud DNS zones where DNSSEC is disabled using Security Command Center findings (DNSSEC_DISABLED).
  Disabling DNSSEC increases risk of DNS hijacking and man-in-the-middle attacks. This analytic rule alerts on findings where DNSSEC is reported as disabled for a managed zone.
triggerOperator: gt
status: Available
queryFrequency: 1h
id: a9c7a4be-b7e7-4045-8028-0d1ffaa049af
name: GCP Security Command Center - Detect DNSSEC disabled for DNS zones
severity: Medium
query: |
  GoogleCloudSCC
  | where tostring(Findings.state) == "ACTIVE"
  | extend FindingsJson = parse_json(Findings)
  | extend FindingCategory = tostring(FindingsJson.category)
  | where FindingCategory == "DNSSEC_DISABLED"
  | extend ResourceName = tostring(FindingsJson.resourceName)
  | extend
    ResourceType = tostring(FindingsResource.type),
    ExternalUri = tostring(FindingsJson.externalUri),
    SourceProps = parse_json(tostring(FindingsJson.sourceProperties)),
    GcpResource = parse_json(tostring(FindingsJson.resource))
  // Extract project and managed zone from resourceName like //dns.googleapis.com/projects/PROJECT/managedZones/ZONE
  | extend ProjectName = extract(@"projects/([^/]+)", 1, ResourceName)
  | extend ManagedZone = extract(@"managedZones/([^/]+)", 1, ResourceName)
  | extend Severity = tostring(FindingsJson.severity)
  | summarize
    TimeGenerated = max(TimeGenerated)
    by ProjectName, ManagedZone, ResourceType, ResourceName, Severity, ExternalUri
queryPeriod: 1h
customDetails:
  ProjectName: ProjectName
  ManagedZone: ManagedZone
  ExternalUri: ExternalUri

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "apiVersion": "2024-01-01-preview",
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/a9c7a4be-b7e7-4045-8028-0d1ffaa049af')]",
      "kind": "Scheduled",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/a9c7a4be-b7e7-4045-8028-0d1ffaa049af')]",
      "properties": {
        "alertDetailsOverride": {
          "alertDescriptionFormat": "DNSSEC is disabled for managed zone {{ManagedZone}} in project {{ProjectName}}. Review the zone configuration and enable DNSSEC where appropriate.",
          "alertDisplayNameFormat": "GCP DNS zone {{ManagedZone}} has DNSSEC disabled"
        },
        "alertRuleTemplateName": "a9c7a4be-b7e7-4045-8028-0d1ffaa049af",
        "customDetails": {
          "ExternalUri": "ExternalUri",
          "ManagedZone": "ManagedZone",
          "ProjectName": "ProjectName"
        },
        "description": "Detects Google Cloud DNS zones where DNSSEC is disabled using Security Command Center findings (DNSSEC_DISABLED).\nDisabling DNSSEC increases risk of DNS hijacking and man-in-the-middle attacks. This analytic rule alerts on findings where DNSSEC is reported as disabled for a managed zone.\n",
        "displayName": "GCP Security Command Center - Detect DNSSEC disabled for DNS zones",
        "enabled": true,
        "entityMappings": [
          {
            "entityType": "CloudApplication",
            "fieldMappings": [
              {
                "columnName": "ResourceName",
                "identifier": "Name"
              }
            ]
          }
        ],
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Google%20Cloud%20Platform%20Security%20Command%20Center/Analytic%20Rules/GCPDNSSECDisabled.yaml",
        "query": "GoogleCloudSCC\n| where tostring(Findings.state) == \"ACTIVE\"\n| extend FindingsJson = parse_json(Findings)\n| extend FindingCategory = tostring(FindingsJson.category)\n| where FindingCategory == \"DNSSEC_DISABLED\"\n| extend ResourceName = tostring(FindingsJson.resourceName)\n| extend\n  ResourceType = tostring(FindingsResource.type),\n  ExternalUri = tostring(FindingsJson.externalUri),\n  SourceProps = parse_json(tostring(FindingsJson.sourceProperties)),\n  GcpResource = parse_json(tostring(FindingsJson.resource))\n// Extract project and managed zone from resourceName like //dns.googleapis.com/projects/PROJECT/managedZones/ZONE\n| extend ProjectName = extract(@\"projects/([^/]+)\", 1, ResourceName)\n| extend ManagedZone = extract(@\"managedZones/([^/]+)\", 1, ResourceName)\n| extend Severity = tostring(FindingsJson.severity)\n| summarize\n  TimeGenerated = max(TimeGenerated)\n  by ProjectName, ManagedZone, ResourceType, ResourceName, Severity, ExternalUri\n",
        "queryFrequency": "PT1H",
        "queryPeriod": "PT1H",
        "severity": "Medium",
        "status": "Available",
        "subTechniques": [
          "T1071.004",
          "T1562.001"
        ],
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "Collection",
          "CommandAndControl",
          "DefenseEvasion"
        ],
        "tags": [
          "CIS GCP Foundation 3.0 3.3",
          "NIST 800-53 R5 AC-18, CM-2, CM-6, CM-7, CM-9",
          "PCI-DSS v4.0 1.1.1, 1.2.1, 1.2.6, 1.2.7, 1.4.2, 1.5.1, 2.1.1, 2.2.1",
          "ISO-27001 v2022 A.8.9",
          "Cloud Controls Matrix 4 IVS-04",
          "NIST Cybersecurity Framework 1.0 PR-IP-1",
          "SOC2 v2017 CC5.2.2",
          "CIS Controls 8.0 4.2"
        ],
        "techniques": [
          "T1071",
          "T1557",
          "T1562"
        ],
        "templateVersion": "1.0.0",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0
      },
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
    }
  ]
}