sql_vulnerability_assessment_scan_results

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

Overview

Name	sql_vulnerability_assessment_scan_results
Type	Resource
Id	azure.security.sql_vulnerability_assessment_scan_results

Fields

vw_sql_vulnerability_assessment_scan_results

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
baseline_adjusted_result	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
resourceId	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
status	text	field from the properties object
type	text	Resource type
workspaceId	text	field from the properties object

sql_vulnerability_assessment_scan_results

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	A vulnerability assessment scan result properties for a single rule.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceId, scanId, scanResultId, workspaceId
list	SELECT	resourceId, scanId, workspaceId

SELECT examples

vw_sql_vulnerability_assessment_scan_results

SELECT
id,
name,
baseline_adjusted_result,
is_trimmed,
query_results,
remediation,
resourceId,
rule_id,
rule_metadata,
scanId,
scanResultId,
status,
type,
workspaceId
FROM azure.security.vw_sql_vulnerability_assessment_scan_results
WHERE resourceId = '{{ resourceId }}'
AND scanId = '{{ scanId }}'
AND workspaceId = '{{ workspaceId }}';

sql_vulnerability_assessment_scan_results

SELECT
id,
name,
properties,
type
FROM azure.security.sql_vulnerability_assessment_scan_results
WHERE resourceId = '{{ resourceId }}'
AND scanId = '{{ scanId }}'
AND workspaceId = '{{ workspaceId }}';