database_sql_vulnerability_assessment_scans

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

Overview

Name	database_sql_vulnerability_assessment_scans
Type	Resource
Id	azure.sql.database_sql_vulnerability_assessment_scans

Fields

vw_database_sql_vulnerability_assessment_scans

Name	Datatype	Description
database	text	field from the properties object
databaseName	text	field from the properties object
end_time	text	field from the properties object
errors	text	field from the properties object
high_severity_failed_rules_count	text	field from the properties object
is_baseline_applied	text	field from the properties object
last_scan_time	text	field from the properties object
low_severity_failed_rules_count	text	field from the properties object
medium_severity_failed_rules_count	text	field from the properties object
resourceGroupName	text	field from the properties object
scanId	text	field from the properties object
scan_id	text	field from the properties object
server	text	field from the properties object
serverName	text	field from the properties object
sql_version	text	field from the properties object
start_time	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
total_failed_rules_count	text	field from the properties object
total_passed_rules_count	text	field from the properties object
total_rules_count	text	field from the properties object
trigger_type	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

database_sql_vulnerability_assessment_scans

Name	Datatype	Description
properties	object	Properties of a vulnerability assessment scan record.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, resourceGroupName, scanId, serverName, subscriptionId, vulnerabilityAssessmentName	Get a database vulnerability assessment scan result.
list_by_sql_vulnerability_assessments	SELECT	databaseName, resourceGroupName, serverName, subscriptionId, vulnerabilityAssessmentName	Lists the vulnerability assessment scans of a database.

SELECT examples

Lists the vulnerability assessment scans of a database.

vw_database_sql_vulnerability_assessment_scans

SELECT
database,
databaseName,
end_time,
errors,
high_severity_failed_rules_count,
is_baseline_applied,
last_scan_time,
low_severity_failed_rules_count,
medium_severity_failed_rules_count,
resourceGroupName,
scanId,
scan_id,
server,
serverName,
sql_version,
start_time,
state,
subscriptionId,
system_data,
total_failed_rules_count,
total_passed_rules_count,
total_rules_count,
trigger_type,
vulnerabilityAssessmentName
FROM azure.sql.vw_database_sql_vulnerability_assessment_scans
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

database_sql_vulnerability_assessment_scans

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