managed_database_vulnerability_assessment_scans

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

Overview

Name	managed_database_vulnerability_assessment_scans
Type	Resource
Id	azure.sql.managed_database_vulnerability_assessment_scans

Fields

vw_managed_database_vulnerability_assessment_scans

Name	Datatype	Description
databaseName	text	field from the properties object
end_time	text	field from the properties object
errors	text	field from the properties object
managedInstanceName	text	field from the properties object
number_of_failed_security_checks	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
start_time	text	field from the properties object
state	text	field from the properties object
storage_container_path	text	field from the properties object
subscriptionId	text	field from the properties object
trigger_type	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

managed_database_vulnerability_assessment_scans

Name	Datatype	Description
properties	object	Properties of a vulnerability assessment scan record.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, managedInstanceName, resourceGroupName, scanId, subscriptionId, vulnerabilityAssessmentName	Gets a vulnerability assessment scan record of a database.
list_by_database	SELECT	databaseName, managedInstanceName, resourceGroupName, subscriptionId, vulnerabilityAssessmentName	Lists the vulnerability assessment scans of a database.
export	EXEC	databaseName, managedInstanceName, resourceGroupName, scanId, subscriptionId, vulnerabilityAssessmentName	Convert an existing scan result to a human readable format. If already exists nothing happens
initiate_scan	EXEC	databaseName, managedInstanceName, resourceGroupName, scanId, subscriptionId, vulnerabilityAssessmentName	Executes a Vulnerability Assessment database scan.

SELECT examples

Lists the vulnerability assessment scans of a database.

vw_managed_database_vulnerability_assessment_scans

SELECT
databaseName,
end_time,
errors,
managedInstanceName,
number_of_failed_security_checks,
resourceGroupName,
scanId,
scan_id,
start_time,
state,
storage_container_path,
subscriptionId,
trigger_type,
vulnerabilityAssessmentName
FROM azure.sql.vw_managed_database_vulnerability_assessment_scans
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

managed_database_vulnerability_assessment_scans

SELECT
properties
FROM azure.sql.managed_database_vulnerability_assessment_scans
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';