Query: Ensure that VA setting Periodic Recurring Scans is enabled on a SQL server

Description

Enable Vulnerability Assessment (VA) Periodic recurring scans for critical SQL servers and corresponding SQL databases.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• 4.2.3 Ensure that VA setting Periodic Recurring Scans is enabled on a SQL server
• 4.2.3 Ensure that VA setting Periodic Recurring Scans is enabled on a SQL server
• 4.2.3 Ensure that Vulnerability Assessment (VA) setting 'Periodic recurring scans' is set to 'on' for each SQL server
• 4.2.3 Ensure that Vulnerability Assessment (VA) setting 'Periodic recurring scans' is set to 'on' for each SQL server
• Ensure that VA setting Periodic Recurring Scans is enabled on a SQL server

SQL