Policy: Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment > Storage Account

Define the storage account where scan results for all databases on the server will be stored.

The storage account name is required. If the container name is not specified, then vulnerability-assessment is taken as default.

example: - teststorageaccount - teststorageaccount/containername<br /><br /> Note: To avoid cross-region reads/writes of audit records, Azure highly recommends to use storage and server located in the same region.

Targets

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment

Controls

Setting this policy configures this control:

Azure > SQL > Server > Advanced Data Security

Policy Packs

This policy setting is used by the following policy packs:

Azure CIS v2.0.0 - Section 4 - Database Services

Policy Specification

Schema Type	`string`
Examples [YAML]	teststorageaccount/container-name

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/other

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/serverVulnerabilityAssessmentStorageAccount"