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_pools.standby_virtual_machine_pools

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, standbyVirtualMachinePoolNameGet a StandbyVirtualMachinePoolResource
list_by_resource_groupselectsubscriptionId, resourceGroupNameList StandbyVirtualMachinePoolResource resources by resource group
list_by_subscriptionselectsubscriptionIdList StandbyVirtualMachinePoolResource resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, standbyVirtualMachinePoolNameCreate a StandbyVirtualMachinePoolResource
updateupdatesubscriptionId, resourceGroupName, standbyVirtualMachinePoolNameUpdate a StandbyVirtualMachinePoolResource
deletedeletesubscriptionId, resourceGroupName, standbyVirtualMachinePoolNameDelete 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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
standbyVirtualMachinePoolNamestringName of the standby virtual machine pool
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a StandbyVirtualMachinePoolResource

SELECT
location,
properties,
tags
FROM azure.standby_pools.standby_virtual_machine_pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND standbyVirtualMachinePoolName = '{{ standbyVirtualMachinePoolName }}' -- required
;

INSERT examples

Create a StandbyVirtualMachinePoolResource

INSERT INTO azure.standby_pools.standby_virtual_machine_pools (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
standbyVirtualMachinePoolName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ standbyVirtualMachinePoolName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Update a StandbyVirtualMachinePoolResource

UPDATE azure.standby_pools.standby_virtual_machine_pools
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND standbyVirtualMachinePoolName = '{{ standbyVirtualMachinePoolName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Delete a StandbyVirtualMachinePoolResource

DELETE FROM azure.standby_pools.standby_virtual_machine_pools
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND standbyVirtualMachinePoolName = '{{ standbyVirtualMachinePoolName }}' --required
;