Query: Ensure instances stopped for over 90 days are removed

Description

Enable this rule to help with the baseline configuration of Amazon Elastic Compute Cloud (Amazon EC2) instances by checking whether Amazon 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:

• 2.11 Ensure instances stopped for over 90 days are removed
• Ensure instances stopped for over 90 days are removed

SQL