Detection: VPC Route Table Route Disassociated

Overview

Detect when a Virtual Private Cloud (VPC) route table route was disassociated. Disassociating a route can disrupt traffic flow, leading to communication failures and potential application downtime. This may indicate unauthorized changes, misconfigurations, or malicious activity affecting network stability.

References:

Usage

Run the detection in your terminal:

powerpipe detection run aws_cloudtrail_log_detections.detection.vpc_route_table_route_disassociated

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run aws_cloudtrail_log_detections.detection.vpc_route_table_route_disassociated --share

SQL

This detection uses a named query:

select
  tp_timestamp as timestamp,
  string_split(event_source, '.') [ 1 ] || ':' || event_name as operation,
  request_parameters ->> 'routeTableId' as resource,
  user_identity.arn as actor,
  tp_source_ip as source_ip,
  tp_index as account_id,
  aws_region as region,
  tp_id as source_id,
  *
from
  aws_cloudtrail_log
where
  event_source = 'ec2.amazonaws.com'
  and event_name = 'DisassociateRouteTable'
  and error_code is null
order by
  event_time desc;

Detection: VPC Route Table Route Disassociated

Overview

Usage

SQL

Tags