Query: EC2 instances should be managed by AWS Systems Manager

Description

An inventory of the software platforms and applications within the organization is possible by managing AWS Elastic Compute Cloud (AWS EC2) instances with AWS Systems Manager.

Query

Tables used in this query:

• aws_ec2_instance
• aws_ssm_managed_instance

Controls using this query:

• 1 EC2 instances should be managed by AWS Systems Manager
• 2.9 Ensure use of AWS Systems Manager to manage EC2 instances
• EC2 instances should be managed by AWS Systems Manager

SQL