Skip to main content

vw_vulnerability_assessment_scans

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

Overview​

Namevw_vulnerability_assessment_scans
TypeView
Idazure.sql.vw_vulnerability_assessment_scans

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.scanId') as "scan_id",
JSON_EXTRACT(properties, '$.triggerType') as "trigger_type",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.server') as "server",
JSON_EXTRACT(properties, '$.database') as "database",
JSON_EXTRACT(properties, '$.sqlVersion') as "sql_version",
JSON_EXTRACT(properties, '$.highSeverityFailedRulesCount') as "high_severity_failed_rules_count",
JSON_EXTRACT(properties, '$.mediumSeverityFailedRulesCount') as "medium_severity_failed_rules_count",
JSON_EXTRACT(properties, '$.lowSeverityFailedRulesCount') as "low_severity_failed_rules_count",
JSON_EXTRACT(properties, '$.totalPassedRulesCount') as "total_passed_rules_count",
JSON_EXTRACT(properties, '$.totalFailedRulesCount') as "total_failed_rules_count",
JSON_EXTRACT(properties, '$.totalRulesCount') as "total_rules_count",
JSON_EXTRACT(properties, '$.isBaselineApplied') as "is_baseline_applied",
JSON_EXTRACT(properties, '$.lastScanTime') as "last_scan_time",
subscriptionId,
resourceGroupName,
serverName,
vulnerabilityAssessmentName,
scanId,
systemDatabaseName
FROM azure.sql.vulnerability_assessment_scans
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND vulnerabilityAssessmentName = 'replace-me' AND systemDatabaseName = 'replace-me';