Query: Ensure that a 'Diagnostic Setting' exists for Subscription Activity Logs

Description

Enable Diagnostic settings for exporting activity logs. Diagnostic settings are available for each individual resource within a subscription. Settings should be configured for all appropriate resources for your environment.

Query

Tables used in this query:

• azure_diagnostic_setting
• azure_subscription

Controls using this query:

• 6.1.1.1 Ensure that a 'Diagnostic Setting' exists for Subscription Activity Logs
• Ensure that a 'Diagnostic Setting' exists for Subscription Activity Logs

SQL