availability_sets

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

Overview

Name	availability_sets
Type	Resource
Id	azure.system_center_vm_manager.availability_sets

Fields

vw_availability_sets

Name	Datatype	Description
availabilitySetResourceName	text	field from the properties object
availability_set_name	text	field from the properties object
extended_location	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
vmm_server_id	text	field from the properties object

availability_sets

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

Methods

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

SELECT examples

List of AvailabilitySets in a subscription.

vw_availability_sets

SELECT
availabilitySetResourceName,
availability_set_name,
extended_location,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
vmm_server_id
FROM azure.system_center_vm_manager.vw_availability_sets
WHERE subscriptionId = '{{ subscriptionId }}';

availability_sets

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

INSERT example

Use the following StackQL query and manifest file to create a new availability_sets resource.

All Properties

/*+ create */
INSERT INTO azure.system_center_vm_manager.availability_sets (
availabilitySetResourceName,
resourceGroupName,
subscriptionId,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT 
'{{ availabilitySetResourceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__extendedLocation }}',
'{{ properties }}',
'{{ extendedLocation }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: availabilitySetName
          value: string
        - name: vmmServerId
          value: string
        - name: provisioningState
          value: []
    - name: extendedLocation
      value:
        - name: type
          value: string
        - name: name
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a availability_sets resource.

/*+ update */
UPDATE azure.system_center_vm_manager.availability_sets
SET 
tags = '{{ tags }}'
WHERE 
availabilitySetResourceName = '{{ availabilitySetResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified availability_sets resource.

/*+ delete */
DELETE FROM azure.system_center_vm_manager.availability_sets
WHERE availabilitySetResourceName = '{{ availabilitySetResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';