Query: Vulnerability assessment should be enabled on SQL Managed Instance

Description

Audit each SQL Managed Instance which doesn't have recurring vulnerability assessment scans enabled. Vulnerability assessment can discover, track, and help you remediate potential database vulnerabilities.

Query

Tables used in this query:

• azure_mssql_managed_instance
• azure_subscription

Controls using this query:

• Vulnerability assessment should be enabled on SQL Managed Instance

SQL