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

Description

Ensure that all Secrets 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_secret
• azure_subscription

Controls using this query:

• 3.3.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 8.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 8.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 8.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 8.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 8.3.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• 9.3.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults
• Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults

SQL