Skip to main content

standby_virtual_machine_pools

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

Overview

Namestandby_virtual_machine_pools
TypeResource
Idazure.standby_pool.standby_virtual_machine_pools

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
attachedVirtualMachineScaleSetIdstringSpecifies the fully qualified resource ID of a virtual machine scale set the pool is attached to.
elasticityProfileobjectSpecifies the elasticity profile of the standby virtual machine pools.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringThe status of the last operation. Known values are: "Succeeded", "Failed", "Canceled", and "Deleting". (Succeeded, Failed, Canceled, Deleting)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
virtualMachineStatestringSpecifies the desired state of virtual machines in the pool. Required. Known values are: "Running", "Deallocated", and "Hibernated". (Running, Deallocated, Hibernated)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, standby_virtual_machine_pool_name, subscription_idGet a StandbyVirtualMachinePoolResource.
list_by_resource_groupselectresource_group_name, subscription_idList StandbyVirtualMachinePoolResource resources by resource group.
list_by_subscriptionselectsubscription_idList StandbyVirtualMachinePoolResource resources by subscription ID.
create_or_updateinsertresource_group_name, standby_virtual_machine_pool_name, subscription_id, locationCreate a StandbyVirtualMachinePoolResource.
updateupdateresource_group_name, standby_virtual_machine_pool_name, subscription_idUpdate a StandbyVirtualMachinePoolResource.
create_or_updatereplaceresource_group_name, standby_virtual_machine_pool_name, subscription_id, locationCreate a StandbyVirtualMachinePoolResource.
deletedeleteresource_group_name, standby_virtual_machine_pool_name, subscription_idDelete a StandbyVirtualMachinePoolResource.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
standby_virtual_machine_pool_namestringName of the standby virtual machine pool. Required.
subscription_idstring

SELECT examples

Get a StandbyVirtualMachinePoolResource.

SELECT
id,
name,
attachedVirtualMachineScaleSetId,
elasticityProfile,
location,
provisioningState,
systemData,
tags,
type,
virtualMachineState
FROM azure.standby_pool.standby_virtual_machine_pools
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND standby_virtual_machine_pool_name = '{{ standby_virtual_machine_pool_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a StandbyVirtualMachinePoolResource.

INSERT INTO azure.standby_pool.standby_virtual_machine_pools (
tags,
location,
properties,
resource_group_name,
standby_virtual_machine_pool_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ standby_virtual_machine_pool_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a StandbyVirtualMachinePoolResource.

UPDATE azure.standby_pool.standby_virtual_machine_pools
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND standby_virtual_machine_pool_name = '{{ standby_virtual_machine_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Create a StandbyVirtualMachinePoolResource.

REPLACE azure.standby_pool.standby_virtual_machine_pools
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND standby_virtual_machine_pool_name = '{{ standby_virtual_machine_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a StandbyVirtualMachinePoolResource.

DELETE FROM azure.standby_pool.standby_virtual_machine_pools
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND standby_virtual_machine_pool_name = '{{ standby_virtual_machine_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;