Control: 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.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.mssql_managed_instance_vulnerability_assessment_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.mssql_managed_instance_vulnerability_assessment_enabled --share
SQL
This control uses a named query:
mssql_managed_instance_vulnerability_assessment_enabled