Skip to main content

virtual_machine_instances

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

Overview

Namevirtual_machine_instances
TypeResource
Idazure.system_center_vm_manager.virtual_machine_instances

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectGets or sets the extended location.
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectresourceUriLists all of the virtual machine instances within the specified parent resource.
getselectresourceUriRetrieves information about a virtual machine instance.
create_or_updateinsertresourceUri, data__extendedLocationThe operation to create or update a virtual machine instance. Please note some properties can be set only during virtual machine instance creation.
updateupdateresourceUriThe operation to update a virtual machine instance.
deletedeleteresourceUriforce, deleteFromHostThe operation to delete a virtual machine instance.
restartexecresourceUriThe operation to restart a virtual machine instance.
restore_checkpointexecresourceUriRestores to a checkpoint in virtual machine instance.
startexecresourceUriThe operation to start a virtual machine instance.
stopexecresourceUriThe operation to power off (stop) a virtual machine instance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceUristringThe fully qualified Azure Resource manager identifier of the resource.
deleteFromHoststringWhether to disable the VM from azure and also delete it from Vmm.
forcestringForces the resource to be deleted.

SELECT examples

Lists all of the virtual machine instances within the specified parent resource.

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

INSERT examples

The operation to create or update a virtual machine instance. Please note some properties can be set only during virtual machine instance creation.

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

UPDATE examples

The operation to update a virtual machine instance.

UPDATE azure.system_center_vm_manager.virtual_machine_instances
SET
data__properties = '{{ properties }}'
WHERE
resourceUri = '{{ resourceUri }}' --required
RETURNING
extendedLocation,
properties;

DELETE examples

The operation to delete a virtual machine instance.

DELETE FROM azure.system_center_vm_manager.virtual_machine_instances
WHERE resourceUri = '{{ resourceUri }}' --required
AND force = '{{ force }}'
AND deleteFromHost = '{{ deleteFromHost }}'
;

Lifecycle Methods

The operation to restart a virtual machine instance.

EXEC azure.system_center_vm_manager.virtual_machine_instances.restart 
@resourceUri='{{ resourceUri }}' --required
;