assignments

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

Overview

Name	assignments
Type	Resource
Id	azure.guest_configuration.assignments

Fields

vw_assignments

Name	Datatype	Description
assignment_hash	text	field from the properties object
compliance_status	text	field from the properties object
context	text	field from the properties object
guestConfigurationAssignmentName	text	field from the properties object
guest_configuration	text	field from the properties object
last_compliance_status_checked	text	field from the properties object
latest_assignment_report	text	field from the properties object
latest_report_id	text	field from the properties object
parameter_hash	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_type	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
target_resource_id	text	field from the properties object
vmName	text	field from the properties object
vmss_vm_list	text	field from the properties object

assignments

Name	Datatype	Description
properties	object	Guest configuration assignment properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	guestConfigurationAssignmentName, resourceGroupName, subscriptionId, vmName	Get information about a guest configuration assignment
list	SELECT	resourceGroupName, subscriptionId, vmName	List all guest configuration assignments for a virtual machine.
create_or_update	INSERT	guestConfigurationAssignmentName, resourceGroupName, subscriptionId, vmName	Creates an association between a VM and guest configuration
delete	DELETE	guestConfigurationAssignmentName, resourceGroupName, subscriptionId, vmName	Delete a guest configuration assignment
rg_list	EXEC	resourceGroupName, subscriptionId	List all guest configuration assignments for a resource group.
subscription_list	EXEC	subscriptionId	List all guest configuration assignments for a subscription.

SELECT examples

List all guest configuration assignments for a virtual machine.

vw_assignments

SELECT
assignment_hash,
compliance_status,
context,
guestConfigurationAssignmentName,
guest_configuration,
last_compliance_status_checked,
latest_assignment_report,
latest_report_id,
parameter_hash,
provisioning_state,
resourceGroupName,
resource_type,
subscriptionId,
system_data,
target_resource_id,
vmName,
vmss_vm_list
FROM azure.guest_configuration.vw_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmName = '{{ vmName }}';

assignments

SELECT
properties,
systemData
FROM azure.guest_configuration.assignments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmName = '{{ vmName }}';

INSERT example

Use the following StackQL query and manifest file to create a new assignments resource.

All Properties

/*+ create */
INSERT INTO azure.guest_configuration.assignments (
guestConfigurationAssignmentName,
resourceGroupName,
subscriptionId,
vmName,
properties
)
SELECT 
'{{ guestConfigurationAssignmentName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vmName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: targetResourceId
          value: string
        - name: guestConfiguration
          value:
            - name: kind
              value: string
            - name: name
              value: string
            - name: version
              value: string
            - name: contentUri
              value: string
            - name: contentHash
              value: string
            - name: contentManagedIdentity
              value: string
            - name: assignmentType
              value: string
            - name: assignmentSource
              value: string
            - name: contentType
              value: string
            - name: configurationParameter
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
            - name: configurationProtectedParameter
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
            - name: configurationSetting
              value:
                - name: configurationMode
                  value: string
                - name: allowModuleOverwrite
                  value: boolean
                - name: actionAfterReboot
                  value: string
                - name: refreshFrequencyMins
                  value: number
                - name: rebootIfNeeded
                  value: boolean
                - name: configurationModeFrequencyMins
                  value: number
        - name: complianceStatus
          value: string
        - name: lastComplianceStatusChecked
          value: string
        - name: latestReportId
          value: string
        - name: parameterHash
          value: string
        - name: latestAssignmentReport
          value:
            - name: id
              value: string
            - name: reportId
              value: string
            - name: assignment
              value:
                - name: name
                  value: string
                - name: configuration
                  value:
                    - name: name
                      value: string
                    - name: version
                      value: string
            - name: vm
              value:
                - name: id
                  value: string
                - name: uuid
                  value: string
            - name: startTime
              value: string
            - name: endTime
              value: string
            - name: complianceStatus
              value: string
            - name: operationType
              value: string
            - name: resources
              value:
                - - name: complianceStatus
                    value: string
                  - name: resourceId
                    value: string
                  - name: reasons
                    value:
                      - - name: phrase
                          value: string
                        - name: code
                          value: string
                  - name: properties
                    value: object
        - name: context
          value: string
        - name: assignmentHash
          value: string
        - name: provisioningState
          value: string
        - name: resourceType
          value: string
        - name: vmssVMList
          value:
            - - name: vmId
                value: string
              - name: vmResourceId
                value: string
              - name: complianceStatus
                value: string
              - name: latestReportId
                value: string
              - name: lastComplianceChecked
                value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

DELETE example

Deletes the specified assignments resource.

/*+ delete */
DELETE FROM azure.guest_configuration.assignments
WHERE guestConfigurationAssignmentName = '{{ guestConfigurationAssignmentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmName = '{{ vmName }}';