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 loginpowerpipe 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_logwhere event_source = 'ec2.amazonaws.com' and event_name = 'DeleteSecurityGroup' and error_code is null
order by event_time desc;