availability_sets

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

Overview

Name	availability_sets
Type	Resource
Id	azure.system_center_vm_manager.availability_sets

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
extendedLocation	object	The extended location.
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

list_by_resource_group

Azure operation completed successfully.

Name	Datatype	Description
extendedLocation	object	The extended location.
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

list_by_subscription

Azure operation completed successfully.

Name	Datatype	Description
extendedLocation	object	The extended location.
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, availabilitySetResourceName		Implements AvailabilitySet GET method.
list_by_resource_group	select	subscriptionId, resourceGroupName		List of AvailabilitySets in a resource group.
list_by_subscription	select	subscriptionId		List of AvailabilitySets in a subscription.
create_or_update	insert	subscriptionId, resourceGroupName, availabilitySetResourceName, data__extendedLocation		Onboards the ScVmm availability set as an Azure resource.
update	update	subscriptionId, resourceGroupName, availabilitySetResourceName		Updates the AvailabilitySets resource.
delete	delete	subscriptionId, resourceGroupName, availabilitySetResourceName	force	Deregisters the ScVmm availability set from Azure.

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.

Name	Datatype	Description
availabilitySetResourceName	string	Name of the AvailabilitySet.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.
force	string	Forces the resource to be deleted.

SELECT examples

get

Implements AvailabilitySet GET method.

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.system_center_vm_manager.availability_sets
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND availabilitySetResourceName = '{{ availabilitySetResourceName }}' -- required
;

list_by_resource_group

List of AvailabilitySets in a resource group.

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.system_center_vm_manager.availability_sets
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
;

list_by_subscription

List of AvailabilitySets in a subscription.

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.system_center_vm_manager.availability_sets
WHERE subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

create_or_update

Onboards the ScVmm availability set as an Azure resource.

INSERT INTO azure.system_center_vm_manager.availability_sets (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
availabilitySetResourceName
)
SELECT 
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ availabilitySetResourceName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

Manifest

# Description fields are for documentation purposes
- name: availability_sets
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the availability_sets resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the availability_sets resource.
    - name: availabilitySetResourceName
      value: string
      description: Required parameter for the availability_sets resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.
    - name: extendedLocation
      value: object
      description: |
        The extended location.
    - name: tags
      value: object
      description: |
        Resource tags.
    - name: location
      value: string
      description: |
        The geo-location where the resource lives

UPDATE examples

update

Updates the AvailabilitySets resource.

UPDATE azure.system_center_vm_manager.availability_sets
SET 
data__tags = '{{ tags }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND availabilitySetResourceName = '{{ availabilitySetResourceName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

delete

Deregisters the ScVmm availability set from Azure.

DELETE FROM azure.system_center_vm_manager.availability_sets
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND availabilitySetResourceName = '{{ availabilitySetResourceName }}' --required
AND force = '{{ force }}'
;