Query: Count the number of patches installed from patch base line

Description

Determine the total number of installed patches from a baseline to assess the level of system updates in your AWS managed instances. This can help in identifying systems that may be lagging in updates, aiding in maintaining security and performance standards.

Query

Tables used in this query:

• aws_ssm_managed_instance_patch_state

SQL