Skip to main content

vw_assignments

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

Overview​

Namevw_assignments
TypeView
Idazure.guest_configuration.vw_assignments

Fields​

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

SQL Definition​

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,
vmName,
guestConfigurationAssignmentName
FROM azure.guest_configuration.assignments
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmName = 'replace-me';