vulnerability_assessment_scans

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

Overview

Name	vulnerability_assessment_scans
Type	Resource
Id	azure.sql.vulnerability_assessment_scans

Fields

vw_vulnerability_assessment_scans

Name	Datatype	Description
database	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
systemDatabaseName	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

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	resourceGroupName, scanId, serverName, subscriptionId, systemDatabaseName, vulnerabilityAssessmentName	Get a system database vulnerability assessment scan record.
list_by_sql_vulnerability_assessments	SELECT	resourceGroupName, serverName, subscriptionId, systemDatabaseName, vulnerabilityAssessmentName	Lists the vulnerability assessment scans of a database.

SELECT examples

Lists the vulnerability assessment scans of a database.

vw_vulnerability_assessment_scans

SELECT
database,
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,
systemDatabaseName,
system_data,
total_failed_rules_count,
total_passed_rules_count,
total_rules_count,
trigger_type,
vulnerabilityAssessmentName
FROM azure.sql.vw_vulnerability_assessment_scans
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND systemDatabaseName = '{{ systemDatabaseName }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

vulnerability_assessment_scans

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