Query: EC2 stopped instances should be removed in 30 days

Description

Enable this rule to help with the baseline configuration of AWS Elastic Compute Cloud (AWS EC2) instances by checking whether AWS EC2 instances have been stopped for more than the allowed number of days, according to your organization's standards.

Query

Tables used in this query:

• aws_ec2_instance

Controls using this query:

• 4 Stopped EC2 instances should be removed after a specified time period
• EC2 stopped instances should be removed in 30 days

SQL