Query: Email notification to subscription owner for high severity alerts should be enabled

Description

To ensure your subscription owners are notified when there is a potential security breach in their subscription, set email notifications to subscription owners for high severity alerts in Security Center.

Query

Tables used in this query:

• azure_security_center_contact
• azure_subscription

Controls using this query:

• 2.1.17 Ensure That 'All users with the following roles' is set to 'Owner'
• 2.1.18 Ensure That 'All users with the following roles' is set to 'Owner'
• 2.15 Ensure that 'All users with the following roles' is set to 'Owner'
• 2.15 Ensure that 'All users with the following roles' is set to 'Owner'
• 2.3.1 Ensure That 'All users with the following roles' is set to 'Owner'
• 3.1.12 Ensure That 'All users with the following roles' is set to 'Owner'
• 8.1.12 Ensure That 'All users with the following roles' is set to 'Owner'
• 9.1.12 Ensure That 'All users with the following roles' is set to 'Owner'
• Email notification to subscription owner for high severity alerts should be enabled

SQL