machines

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

Overview

Name	machines
Type	Resource
Id	azure.hybrid_compute.machines

Fields

vw_machines

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
agent_version	text	field from the properties object
client_public_key	text	field from the properties object
display_name	text	field from the properties object
error_details	text	field from the properties object
identity	text	field from the properties object
last_status_change	text	field from the properties object
location	text	Resource location
machine_fqdn	text	field from the properties object
os_name	text	field from the properties object
os_profile	text	field from the properties object
os_version	text	field from the properties object
physical_location	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags
type	text	Resource type
vm_id	text	field from the properties object

machines

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
identity	object
location	string	Resource location
properties	object	Describes the properties of a hybrid machine.
tags	object	Resource tags
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId	Retrieves information about the model view or the instance view of a hybrid machine.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all the hybrid machines in the specified resource group. Use the nextLink property in the response to get the next page of hybrid machines.
list_by_subscription	SELECT	subscriptionId	Lists all the hybrid machines in the specified subscription. Use the nextLink property in the response to get the next page of hybrid machines.
create_or_update	INSERT	name, resourceGroupName, subscriptionId	The operation to create or update a hybrid machine resource identity in Azure.
delete	DELETE	name, resourceGroupName, subscriptionId	The operation to remove a hybrid machine identity in Azure.
update	UPDATE	name, resourceGroupName, subscriptionId	The operation to update a hybrid machine.
reconnect	EXEC	name, resourceGroupName, subscriptionId	The operation to reconnect a hybrid machine resource to its identity in Azure.

SELECT examples

Lists all the hybrid machines in the specified subscription. Use the nextLink property in the response to get the next page of hybrid machines.

vw_machines

SELECT
id,
name,
agent_version,
client_public_key,
display_name,
error_details,
identity,
last_status_change,
location,
machine_fqdn,
os_name,
os_profile,
os_version,
physical_location,
provisioning_state,
resourceGroupName,
status,
subscriptionId,
tags,
type,
vm_id
FROM azure.hybrid_compute.vw_machines
WHERE subscriptionId = '{{ subscriptionId }}';

machines

SELECT
id,
name,
identity,
location,
properties,
tags,
type
FROM azure.hybrid_compute.machines
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.hybrid_compute.machines (
name,
resourceGroupName,
subscriptionId,
properties,
location,
tags,
identity
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}',
'{{ identity }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: osProfile
          value:
            - name: computerName
              value: string
        - name: provisioningState
          value: string
        - name: status
          value: string
        - name: lastStatusChange
          value: string
        - name: errorDetails
          value:
            - - name: code
                value: string
              - name: message
                value: string
              - name: target
                value: string
              - name: details
                value:
                  - - name: code
                      value: string
                    - name: message
                      value: string
                    - name: target
                      value: string
                    - name: details
                      value:
                        - - name: code
                            value: string
                          - name: message
                            value: string
                          - name: target
                            value: string
                          - name: details
                            value:
                              - - name: code
                                  value: string
                                - name: message
                                  value: string
                                - name: target
                                  value: string
                                - name: details
                                  value:
                                    - - name: code
                                        value: string
                                      - name: message
                                        value: string
                                      - name: target
                                        value: string
                                      - name: details
                                        value:
                                          - - name: code
                                              value: string
                                            - name: message
                                              value: string
                                            - name: target
                                              value: string
                                            - name: details
                                              value:
                                                - - name: code
                                                    value: string
                                                  - name: message
                                                    value: string
                                                  - name: target
                                                    value: string
                                                  - name: details
                                                    value:
                                                      - - name: code
                                                          value: string
                                                        - name: message
                                                          value: string
                                                        - name: target
                                                          value: string
                                                        - name: details
                                                          value:
                                                            - - name: code
                                                                value: string
                                                              - name: message
                                                                value: string
                                                              - name: target
                                                                value: string
                                                              - name: details
                                                                value:
                                                                  - []
        - name: agentVersion
          value: string
        - name: vmId
          value: string
        - name: displayName
          value: string
        - name: machineFqdn
          value: string
        - name: physicalLocation
          value: string
        - name: clientPublicKey
          value: string
        - name: osName
          value: string
        - name: osVersion
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string

UPDATE example

Updates a machines resource.

/*+ update */
UPDATE azure.hybrid_compute.machines
SET 
identity = '{{ identity }}',
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE 
name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified machines resource.

/*+ delete */
DELETE FROM azure.hybrid_compute.machines
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';