vw_assessments_metadata

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

Overview

Name	vw_assessments_metadata
Type	View
Id	azure.security.vw_assessments_metadata

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.publishDates') as "publish_dates",
JSON_EXTRACT(properties, '$.plannedDeprecationDate') as "planned_deprecation_date",
JSON_EXTRACT(properties, '$.tactics') as "tactics",
JSON_EXTRACT(properties, '$.techniques') as "techniques",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.policyDefinitionId') as "policy_definition_id",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.remediationDescription') as "remediation_description",
JSON_EXTRACT(properties, '$.categories') as "categories",
JSON_EXTRACT(properties, '$.severity') as "severity",
JSON_EXTRACT(properties, '$.userImpact') as "user_impact",
JSON_EXTRACT(properties, '$.implementationEffort') as "implementation_effort",
JSON_EXTRACT(properties, '$.threats') as "threats",
JSON_EXTRACT(properties, '$.preview') as "preview",
JSON_EXTRACT(properties, '$.assessmentType') as "assessment_type",
JSON_EXTRACT(properties, '$.partnerData') as "partner_data",
subscriptionId,
assessmentMetadataName
FROM azure.security.assessments_metadata
WHERE subscriptionId = 'replace-me' AND assessmentMetadataName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.publishDates') as "publish_dates",
json_extract_path_text(properties, '$.plannedDeprecationDate') as "planned_deprecation_date",
json_extract_path_text(properties, '$.tactics') as "tactics",
json_extract_path_text(properties, '$.techniques') as "techniques",
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.policyDefinitionId') as "policy_definition_id",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.remediationDescription') as "remediation_description",
json_extract_path_text(properties, '$.categories') as "categories",
json_extract_path_text(properties, '$.severity') as "severity",
json_extract_path_text(properties, '$.userImpact') as "user_impact",
json_extract_path_text(properties, '$.implementationEffort') as "implementation_effort",
json_extract_path_text(properties, '$.threats') as "threats",
json_extract_path_text(properties, '$.preview') as "preview",
json_extract_path_text(properties, '$.assessmentType') as "assessment_type",
json_extract_path_text(properties, '$.partnerData') as "partner_data",
subscriptionId,
assessmentMetadataName
FROM azure.security.assessments_metadata
WHERE subscriptionId = 'replace-me' AND assessmentMetadataName = 'replace-me';