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