Query: SSM managed instance associations should be compliant

Description

Use AWS Systems Manager Associations to help with inventory of software platforms and applications within an organization.

Query

Tables used in this query:

• aws_ssm_managed_instance
• aws_ssm_managed_instance_compliance

Controls using this query:

• 3 Instances managed by Systems Manager should have an association compliance status of COMPLIANT
• SSM managed instance associations should be compliant

SQL