Query: Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults

Description

Ensure that all Keys in Role Based Access Control (RBAC) Azure Key Vaults have an expiration date set.

Query

Tables used in this query:

• azure_key_vault
• azure_key_vault_key
• azure_subscription

Controls using this query:

• 3.3.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 8.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 8.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 8.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 8.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 8.3.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• 9.3.1 Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults
• Ensure that the Expiration Date is set for all Keys in RBAC Key Vaults

SQL