turbot/tailpipe-mod-gcp-audit-log-detections

Detection: DNS Managed Zone Deleted

Overview

Detect when a DNS managed zone was deleted. Unauthorized or accidental deletions can disrupt domain configurations, cause service outages, or expose systems to threats. Monitoring these actions ensures the integrity and availability of DNS configurations.

References:

Usage

Run the detection in your terminal:

powerpipe detection run gcp_audit_log_detections.detection.dns_managed_zone_deleted

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run gcp_audit_log_detections.detection.dns_managed_zone_deleted --share

SQL

This detection uses a named query:

select
tp_timestamp as timestamp,
method_name as operation,
resource_name as resource,
authentication_info.principal_email as actor,
tp_source_ip as source_ip,
tp_index as project,
tp_id as source_id,
-- Create new aliases to preserve original row data
*
from
gcp_audit_log
where
service_name = 'dns.googleapis.com'
and method_name ilike 'dns.managedzones.delete'
and severity != 'Error'
-- TODO: Do we need to check operation?
-- and (operation_src is null or operation_src.last = true)
order by
timestamp desc;

Tags