Query: Count of non-compliant security patches for each instance

Description

Determine the areas in which non-compliant security patches exist for each instance. This helps in identifying potential security vulnerabilities and aids in maintaining system integrity.

Query

Tables used in this query:

• aws_ssm_managed_instance_patch_state

SQL