turbot/tailpipe-mod-aws-cloudtrail-log-detections

Detection: VPC Security Group Deleted

Overview

Detect when a Virtual Private Cloud (VPC) security group was deleted. Security groups are essential for controlling traffic to resources, and their deletion can disrupt access control or expose resources to unauthorized traffic. Monitoring these events helps ensure proper oversight and prevents potential security or operational issues.

References:

Usage

Run the detection in your terminal:

powerpipe detection run aws_cloudtrail_log_detections.detection.vpc_security_group_deleted

Snapshot and share results via Turbot Pipes:

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

SQL

This detection uses a named query:

select
tp_timestamp as timestamp,
string_split(event_source, '.')[1] || ':' || event_name as operation,
request_parameters ->> 'groupId' 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 = 'DeleteSecurityGroup'
and error_code is null
order by event_time desc;

Tags