database_sql_vulnerability_assessment_scan_results

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

Overview

Name	database_sql_vulnerability_assessment_scan_results
Type	Resource
Id	azure.sql.database_sql_vulnerability_assessment_scan_results

Fields

vw_database_sql_vulnerability_assessment_scan_results

Name	Datatype	Description
baseline_adjusted_result	text	field from the properties object
databaseName	text	field from the properties object
error_message	text	field from the properties object
is_trimmed	text	field from the properties object
query_results	text	field from the properties object
remediation	text	field from the properties object
resourceGroupName	text	field from the properties object
rule_id	text	field from the properties object
rule_metadata	text	field from the properties object
scanId	text	field from the properties object
scanResultId	text	field from the properties object
serverName	text	field from the properties object
status	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_assessment_scan_results

Name	Datatype	Description
properties	object	SQL Vulnerability Assessment scan result properties for a single rule.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, resourceGroupName, scanId, scanResultId, serverName, subscriptionId, vulnerabilityAssessmentName	Gets a vulnerability assessment scan record of a database.
list_by_scan	SELECT	databaseName, resourceGroupName, scanId, serverName, subscriptionId, vulnerabilityAssessmentName	Gets a vulnerability assessment scan record of a database.

SELECT examples

Gets a vulnerability assessment scan record of a database.

vw_database_sql_vulnerability_assessment_scan_results

SELECT
baseline_adjusted_result,
databaseName,
error_message,
is_trimmed,
query_results,
remediation,
resourceGroupName,
rule_id,
rule_metadata,
scanId,
scanResultId,
serverName,
status,
subscriptionId,
system_data,
vulnerabilityAssessmentName
FROM azure.sql.vw_database_sql_vulnerability_assessment_scan_results
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND scanId = '{{ scanId }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

database_sql_vulnerability_assessment_scan_results

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