Query: List of KMS key alias where key rotation disabled on the key

Description

Discover the segments where key rotation is disabled in AWS Key Management Service. This is useful in identifying potential security risks, as disabling key rotation can make cryptographic keys more susceptible to compromise.

Query

Tables used in this query:

• aws_kms_alias

SQL