clouds

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

Overview

Name	clouds
Type	Resource
Id	azure.system_center_vm_manager.clouds

Fields

vw_clouds

Name	Datatype	Description
cloudResourceName	text	field from the properties object
cloud_capacity	text	field from the properties object
cloud_name	text	field from the properties object
extended_location	text	field from the properties object
inventory_item_id	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
storage_qo_s_policies	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
uuid	text	field from the properties object
vmm_server_id	text	field from the properties object

clouds

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	cloudResourceName, resourceGroupName, subscriptionId	Implements Cloud GET method.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List of Clouds in a resource group.
list_by_subscription	SELECT	subscriptionId	List of Clouds in a subscription.
create_or_update	INSERT	cloudResourceName, resourceGroupName, subscriptionId, data__extendedLocation	Onboards the ScVmm fabric cloud as an Azure cloud resource.
delete	DELETE	cloudResourceName, resourceGroupName, subscriptionId	Deregisters the ScVmm fabric cloud from Azure.
update	UPDATE	cloudResourceName, resourceGroupName, subscriptionId	Updates the Clouds resource.

SELECT examples

List of Clouds in a subscription.

vw_clouds

SELECT
cloudResourceName,
cloud_capacity,
cloud_name,
extended_location,
inventory_item_id,
location,
provisioning_state,
resourceGroupName,
storage_qo_s_policies,
subscriptionId,
tags,
uuid,
vmm_server_id
FROM azure.system_center_vm_manager.vw_clouds
WHERE subscriptionId = '{{ subscriptionId }}';

clouds

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: inventoryItemId
          value: string
        - name: uuid
          value: string
        - name: vmmServerId
          value: string
        - name: cloudName
          value: string
        - name: cloudCapacity
          value:
            - name: cpuCount
              value: integer
            - name: memoryMB
              value: integer
            - name: vmCount
              value: integer
        - name: storageQoSPolicies
          value:
            - - name: name
                value: string
              - name: id
                value: string
              - name: iopsMaximum
                value: integer
              - name: iopsMinimum
                value: integer
              - name: bandwidthLimit
                value: integer
              - name: policyId
                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 clouds resource.

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

DELETE example

Deletes the specified clouds resource.

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