vw_assignments_vm_sse

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

Overview

Name	vw_assignments_vm_sse
Type	View
Id	azure.guest_configuration.vw_assignments_vm_sse

Fields

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

SQL Definition

Sqlite3

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.targetResourceId') as "target_resource_id",
JSON_EXTRACT(properties, '$.guestConfiguration') as "guest_configuration",
JSON_EXTRACT(properties, '$.complianceStatus') as "compliance_status",
JSON_EXTRACT(properties, '$.lastComplianceStatusChecked') as "last_compliance_status_checked",
JSON_EXTRACT(properties, '$.latestReportId') as "latest_report_id",
JSON_EXTRACT(properties, '$.parameterHash') as "parameter_hash",
JSON_EXTRACT(properties, '$.latestAssignmentReport') as "latest_assignment_report",
JSON_EXTRACT(properties, '$.context') as "context",
JSON_EXTRACT(properties, '$.assignmentHash') as "assignment_hash",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.resourceType') as "resource_type",
JSON_EXTRACT(properties, '$.vmssVMList') as "vmss_vm_list",
subscriptionId,
resourceGroupName,
vmssName,
name
FROM azure.guest_configuration.assignments_vm_sse
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmssName = 'replace-me';

Postgres

SELECT
systemData as system_data,
json_extract_path_text(properties, '$.targetResourceId') as "target_resource_id",
json_extract_path_text(properties, '$.guestConfiguration') as "guest_configuration",
json_extract_path_text(properties, '$.complianceStatus') as "compliance_status",
json_extract_path_text(properties, '$.lastComplianceStatusChecked') as "last_compliance_status_checked",
json_extract_path_text(properties, '$.latestReportId') as "latest_report_id",
json_extract_path_text(properties, '$.parameterHash') as "parameter_hash",
json_extract_path_text(properties, '$.latestAssignmentReport') as "latest_assignment_report",
json_extract_path_text(properties, '$.context') as "context",
json_extract_path_text(properties, '$.assignmentHash') as "assignment_hash",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.resourceType') as "resource_type",
json_extract_path_text(properties, '$.vmssVMList') as "vmss_vm_list",
subscriptionId,
resourceGroupName,
vmssName,
name
FROM azure.guest_configuration.assignments_vm_sse
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmssName = 'replace-me';