Skip to main content

availability_sets

Creates, updates, deletes, gets or lists an availability_sets resource.

Overview

Nameavailability_sets
TypeResource
Idazure.compute.availability_sets

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.
locationstringThe geo-location where the resource lives. Required.
platformFaultDomainCountintegerFault Domain count.
platformUpdateDomainCountintegerUpdate Domain count.
proximityPlacementGroupobjectSubResource.
scheduledEventsPolicyobjectSpecifies Redeploy, Reboot and ScheduledEventsAdditionalPublishingTargets Scheduled Event related configurations for the availability set.
skuobjectSku of the availability set, only name is required to be set. See AvailabilitySetSkuTypes for possible set of values. Use 'Aligned' for virtual machines with managed disks and 'Classic' for virtual machines with unmanaged disks. Default value is 'Classic'.
statusesarrayThe resource status information.
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".
virtualMachineScaleSetMigrationInfoobjectDescribes the migration properties on the Availability Set.
virtualMachinesarrayA list of references to all virtual machines in the availability set.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, availability_set_name, subscription_idRetrieves information about an availability set.
listselectresource_group_name, subscription_idLists all availability sets in a resource group.
list_by_subscriptionselectsubscription_id$expandLists all availability sets in a subscription.
create_or_updateinsertresource_group_name, availability_set_name, subscription_id, locationCreate or update an availability set.
updateupdateresource_group_name, availability_set_name, subscription_idUpdate an availability set.
create_or_updatereplaceresource_group_name, availability_set_name, subscription_id, locationCreate or update an availability set.
deletedeleteresource_group_name, availability_set_name, subscription_idDelete an availability set.
list_available_sizesexecresource_group_name, availability_set_name, subscription_idLists all available virtual machine sizes that can be used to create a new virtual machine in an existing availability set.
start_migration_to_virtual_machine_scale_setexecresource_group_name, availability_set_name, subscription_id, virtualMachineScaleSetFlexibleStart migration operation on an Availability Set to move its Virtual Machines to a Virtual Machine Scale Set. This should be followed by a migrate operation on each Virtual Machine that triggers a downtime on the Virtual Machine.
cancel_migration_to_virtual_machine_scale_setexecresource_group_name, availability_set_name, subscription_idCancel the migration operation on an Availability Set.
validate_migration_to_virtual_machine_scale_setexecresource_group_name, availability_set_name, subscription_id, virtualMachineScaleSetFlexibleValidates that the Virtual Machines in the Availability Set can be migrated to the provided Virtual Machine Scale Set.
convert_to_virtual_machine_scale_setexecresource_group_name, availability_set_name, subscription_idCreate a new Flexible Virtual Machine Scale Set and migrate all the Virtual Machines in the Availability Set. This does not trigger a downtime on the Virtual Machines.

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
availability_set_namestringThe name of the availability set. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
$expandstringThe expand expression to apply to the operation. Allowed values are 'instanceView'. Default value is None.

SELECT examples

Retrieves information about an availability set.

SELECT
id,
name,
location,
platformFaultDomainCount,
platformUpdateDomainCount,
proximityPlacementGroup,
scheduledEventsPolicy,
sku,
statuses,
systemData,
tags,
type,
virtualMachineScaleSetMigrationInfo,
virtualMachines
FROM azure.compute.availability_sets
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND availability_set_name = '{{ availability_set_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update an availability set.

INSERT INTO azure.compute.availability_sets (
tags,
location,
properties,
sku,
resource_group_name,
availability_set_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ sku }}',
'{{ resource_group_name }}',
'{{ availability_set_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

Update an availability set.

UPDATE azure.compute.availability_sets
SET
tags = '{{ tags }}',
properties = '{{ properties }}',
sku = '{{ sku }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND availability_set_name = '{{ availability_set_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type;

REPLACE examples

Create or update an availability set.

REPLACE azure.compute.availability_sets
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}',
sku = '{{ sku }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND availability_set_name = '{{ availability_set_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

Delete an availability set.

DELETE FROM azure.compute.availability_sets
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND availability_set_name = '{{ availability_set_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Lists all available virtual machine sizes that can be used to create a new virtual machine in an existing availability set.

EXEC azure.compute.availability_sets.list_available_sizes 
@resource_group_name='{{ resource_group_name }}' --required,
@availability_set_name='{{ availability_set_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;