database_sql_vulnerability_assessments_settings

Creates, updates, deletes, gets or lists a database_sql_vulnerability_assessments_settings resource.

Overview

Name	database_sql_vulnerability_assessments_settings
Type	Resource
Id	azure.sql.database_sql_vulnerability_assessments_settings

Fields

vw_database_sql_vulnerability_assessments_settings

Name	Datatype	Description
databaseName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

database_sql_vulnerability_assessments_settings

Name	Datatype	Description
properties	object
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, resourceGroupName, serverName, subscriptionId, vulnerabilityAssessmentName	Gets SQL Vulnerability Assessment policy for database.
list_by_database	SELECT	databaseName, resourceGroupName, serverName, subscriptionId	Lists SQL Vulnerability Assessment policies associated with a database.

SELECT examples

Lists SQL Vulnerability Assessment policies associated with a database.

vw_database_sql_vulnerability_assessments_settings

SELECT
databaseName,
resourceGroupName,
serverName,
state,
subscriptionId,
system_data,
vulnerabilityAssessmentName
FROM azure.sql.vw_database_sql_vulnerability_assessments_settings
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

database_sql_vulnerability_assessments_settings

SELECT
properties,
systemData
FROM azure.sql.database_sql_vulnerability_assessments_settings
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';