sql_vulnerability_assessment_scans

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

Overview

Name	sql_vulnerability_assessment_scans
Type	Resource
Id	azure.security.sql_vulnerability_assessment_scans

Fields

vw_sql_vulnerability_assessment_scans

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

sql_vulnerability_assessment_scans

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	A vulnerability assessment scan record properties.
type	string	Resource type

Methods

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

SELECT examples

vw_sql_vulnerability_assessment_scans

SELECT
id,
name,
database,
end_time,
high_severity_failed_rules_count,
is_baseline_applied,
last_scan_time,
low_severity_failed_rules_count,
medium_severity_failed_rules_count,
resourceId,
scanId,
server,
sql_version,
start_time,
state,
total_failed_rules_count,
total_passed_rules_count,
total_rules_count,
trigger_type,
type,
workspaceId
FROM azure.security.vw_sql_vulnerability_assessment_scans
WHERE resourceId = '{{ resourceId }}'
AND workspaceId = '{{ workspaceId }}';

sql_vulnerability_assessment_scans

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