Query: List non-compliant associations for a managed instance

Description

Determine the areas in which a managed instance is non-compliant. This query is beneficial in identifying instances where the compliance type is 'Association' and the status is not 'COMPLIANT', providing insights into potential areas for improvement.

Query

Tables used in this query:

• aws_ssm_managed_instance_compliance

SQL