sql_pool_vulnerability_assessment_scans

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

Overview

Name	sql_pool_vulnerability_assessment_scans
Type	Resource
Id	azure.synapse.sql_pool_vulnerability_assessment_scans

Fields

vw_sql_pool_vulnerability_assessment_scans

Name	Datatype	Description
end_time	text	field from the properties object
errors	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
sqlPoolName	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
workspaceName	text	field from the properties object

sql_pool_vulnerability_assessment_scans

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

Methods

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

SELECT examples

Lists the vulnerability assessment scans of a SQL pool.

vw_sql_pool_vulnerability_assessment_scans

SELECT
end_time,
errors,
number_of_failed_security_checks,
resourceGroupName,
scanId,
scan_id,
sqlPoolName,
start_time,
state,
storage_container_path,
subscriptionId,
trigger_type,
vulnerabilityAssessmentName,
workspaceName
FROM azure.synapse.vw_sql_pool_vulnerability_assessment_scans
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_vulnerability_assessment_scans

SELECT
properties
FROM azure.synapse.sql_pool_vulnerability_assessment_scans
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}'
AND workspaceName = '{{ workspaceName }}';