Query: Email notification for high severity alerts should be enabled

Description

To ensure the relevant people in your organization are notified when there is a potential security breach in one of your subscriptions, enable email notifications 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.19 Ensure That 'Notify about alerts with the following severity' is Set to 'High'
• 2.1.20 Ensure That 'Notify about alerts with the following severity' is Set to 'High'
• 2.14 Ensure that 'Notify about alerts with the following severity' is set to 'High'
• 2.14 Ensure that 'Notify about alerts with the following severity' is set to 'High'
• 2.3.3 Ensure That 'Notify about alerts with the following severity' is Set to 'High'
• 3.1.14 Ensure That 'Notify about alerts with the following severity' is Set to 'High'
• 8.1.14 Ensure that 'Notify about alerts with the following severity (or higher)' is enabled
• 9.1.14 Ensure that 'Notify about alerts with the following severity (or higher)' is enabled
• Email notification for high severity alerts should be enabled

SQL