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

Description

Ensure that all Secrets in Non Role Based Access Control (RBAC) Azure Key Vaults have an expiration time set.

Query

Tables used in this query:

• azure_key_vault
• azure_key_vault_secret
• azure_subscription

Controls using this query:

• 3.3.4 Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults
• 8.4 Ensure that the Expiration Date is set for all Secrets in Non- RBAC Key Vaults
• 8.4 Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults
• 8.4 Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults
• 8.4 Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults
• Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults

SQL