Query: Get KMS key details of firewalls encrypted with customer managed keys

Description

Identify firewalls that are encrypted with customer-managed keys and gain insights into their key rotation status. This can be useful in ensuring that your organization's encryption practices are in line with its security policies.

Query

Tables used in this query:

• aws_networkfirewall_firewall

SQL