Query: Ensure 'Additional email addresses' is configured with a security contact email

Description

Security Center emails the subscription owners whenever a high-severity alert is triggered for their subscription. You should provide a security contact email address as an additional email address.

Query

Tables used in this query:

• azure_security_center_contact
• azure_subscription

Controls using this query:

• 2.1.18 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 2.1.19 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 2.13 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 2.13 Ensure 'Additional email addresses' is configured with a security contact email
• 2.3.2 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 3.1.13 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 8.1.13 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• 9.1.13 Ensure 'Additional email addresses' is Configured with a Security Contact Email
• Ensure 'Additional email addresses' is configured with a security contact email

SQL