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

Define the storage account where scan results for database 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 > Database

Primary Policy

This policy is used with the following primary policy:

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

Controls

Setting this policy configures this control:

Azure > SQL > Database > Advanced Data Security

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/databaseVulnerabilityAssessmentStorageAccount

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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