Query: Ensure classic logging is enabled for Azure Queue service

Description

This control ensures that classic logging is enabled for the Azure Queue service. It validates whether operations such as enqueue, dequeue, and delete are being captured via the legacy storage logging mechanism. This is especially relevant for older deployments where diagnostic settings are not configured.

Query

Tables used in this query:

• azure_storage_account
• azure_subscription

Controls using this query:

• 3.3 Ensure Storage logging is enabled for Queue service for 'Read', 'Write', and 'Delete' requests
• 3.3 Ensure Storage logging is enabled for Queue service for read, write, and delete requests
• Ensure classic logging is enabled for Azure Queue service

SQL