Query: Ensure that Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners' is set for each SQL Server

Description

Enable Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners'.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• 4.2.5 Ensure that VA setting 'Also send email notifications to admins and subscription owners' is set for a SQL server
• 4.2.5 Ensure that Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners' is set for each SQL server
• 4.2.5 Ensure that Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners' is set for each SQL Server
• 4.2.5 Ensure that Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners' is set for each SQL Server
• Ensure that Vulnerability Assessment (VA) setting 'Also send email notifications to admins and subscription owners' is set for each SQL Server

SQL