virtual_machine_instances

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

Overview

Name	virtual_machine_instances
Type	Resource
Id	azure.system_center_vm_manager.virtual_machine_instances

Fields

Name	Datatype	Description
extendedLocation	object	The extended location.
properties	object	Defines the resource properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceUri	Retrieves information about a virtual machine instance.
list	SELECT	resourceUri	Lists all of the virtual machine instances within the specified parent resource.
create_or_update	INSERT	resourceUri, data__extendedLocation	The operation to create or update a virtual machine instance. Please note some properties can be set only during virtual machine instance creation.
delete	DELETE	resourceUri	The operation to delete a virtual machine instance.
update	UPDATE	resourceUri	The operation to update a virtual machine instance.
restart	EXEC	resourceUri	The operation to restart a virtual machine instance.
restore_checkpoint	EXEC	resourceUri	Restores to a checkpoint in virtual machine instance.
start	EXEC	resourceUri	The operation to start a virtual machine instance.
stop	EXEC	resourceUri	The operation to power off (stop) a virtual machine instance.

SELECT examples

Retrieves information about a virtual machine instance.

SELECT
extendedLocation,
properties
FROM azure.system_center_vm_manager.virtual_machine_instances
WHERE resourceUri = '{{ resourceUri }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.system_center_vm_manager.virtual_machine_instances (
resourceUri,
data__extendedLocation,
properties,
extendedLocation
)
SELECT 
'{{ resourceUri }}',
'{{ data__extendedLocation }}',
'{{ properties }}',
'{{ extendedLocation }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: availabilitySets
          value:
            - - name: id
                value: string
              - name: name
                value: string
        - name: osProfile
          value:
            - name: adminPassword
              value: string
            - name: computerName
              value: string
            - name: osType
              value: []
            - name: osSku
              value: string
            - name: osVersion
              value: string
            - name: domainName
              value: string
            - name: domainUsername
              value: string
            - name: domainPassword
              value: string
            - name: workgroup
              value: string
            - name: productKey
              value: string
            - name: timezone
              value: integer
            - name: runOnceCommands
              value: string
        - name: hardwareProfile
          value:
            - name: memoryMB
              value: integer
            - name: cpuCount
              value: integer
            - name: limitCpuForMigration
              value: []
            - name: dynamicMemoryEnabled
              value: []
            - name: dynamicMemoryMaxMB
              value: integer
            - name: dynamicMemoryMinMB
              value: integer
            - name: isHighlyAvailable
              value: []
        - name: networkProfile
          value:
            - name: networkInterfaces
              value:
                - - name: name
                    value: string
                  - name: displayName
                    value: string
                  - name: ipv4Addresses
                    value:
                      - string
                  - name: ipv6Addresses
                    value:
                      - string
                  - name: macAddress
                    value: string
                  - name: virtualNetworkId
                    value: string
                  - name: networkName
                    value: string
                  - name: ipv4AddressType
                    value: []
                  - name: nicId
                    value: string
        - name: storageProfile
          value:
            - name: disks
              value:
                - - name: name
                    value: string
                  - name: displayName
                    value: string
                  - name: diskId
                    value: string
                  - name: diskSizeGB
                    value: integer
                  - name: maxDiskSizeGB
                    value: integer
                  - name: bus
                    value: integer
                  - name: lun
                    value: integer
                  - name: busType
                    value: string
                  - name: vhdType
                    value: string
                  - name: volumeType
                    value: string
                  - name: vhdFormatType
                    value: string
                  - name: templateDiskId
                    value: string
                  - name: storageQoSPolicy
                    value:
                      - name: name
                        value: string
                      - name: id
                        value: string
                  - name: createDiffDisk
                    value: []
        - name: infrastructureProfile
          value:
            - name: inventoryItemId
              value: string
            - name: vmmServerId
              value: string
            - name: cloudId
              value: string
            - name: templateId
              value: string
            - name: vmName
              value: string
            - name: uuid
              value: string
            - name: lastRestoredVMCheckpoint
              value:
                - name: parentCheckpointID
                  value: string
                - name: checkpointID
                  value: string
                - name: name
                  value: string
                - name: description
                  value: string
            - name: checkpoints
              value:
                - - name: parentCheckpointID
                    value: string
                  - name: checkpointID
                    value: string
                  - name: name
                    value: string
                  - name: description
                    value: string
            - name: checkpointType
              value: string
            - name: generation
              value: integer
            - name: biosGuid
              value: string
        - name: powerState
          value: string
        - name: provisioningState
          value: []
    - name: extendedLocation
      value:
        - name: type
          value: string
        - name: name
          value: string

UPDATE example

Updates a virtual_machine_instances resource.

/*+ update */
UPDATE azure.system_center_vm_manager.virtual_machine_instances
SET 
properties = '{{ properties }}'
WHERE 
resourceUri = '{{ resourceUri }}';

DELETE example

Deletes the specified virtual_machine_instances resource.

/*+ delete */
DELETE FROM azure.system_center_vm_manager.virtual_machine_instances
WHERE resourceUri = '{{ resourceUri }}';