resource_pools

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

Overview

Name	resource_pools
Type	Resource
Id	azure_isv.connected_vsphere.resource_pools

Fields

vw_resource_pools

Name	Datatype	Description
id	text	Gets or sets the Id.
name	text	Gets or sets the name.
cpu_capacity_m_hz	text	field from the properties object
cpu_limit_m_hz	text	field from the properties object
cpu_overall_usage_m_hz	text	field from the properties object
cpu_reservation_m_hz	text	field from the properties object
cpu_shares_level	text	field from the properties object
custom_resource_name	text	field from the properties object
datastore_ids	text	field from the properties object
extended_location	text	field from the properties object
inventory_item_id	text	field from the properties object
kind	text	Metadata used by portal/tooling/etc to render different UX experiences for resources of the same type; e.g. ApiApps are a kind of Microsoft.Web/sites type. If supported, the resource provider must validate and persist this value.
location	text	Gets or sets the location.
mem_capacity_gb	text	field from the properties object
mem_limit_mb	text	field from the properties object
mem_overall_usage_gb	text	field from the properties object
mem_reservation_mb	text	field from the properties object
mem_shares_level	text	field from the properties object
mo_name	text	field from the properties object
mo_ref_id	text	field from the properties object
network_ids	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resourcePoolName	text	field from the properties object
statuses	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Gets or sets the Resource tags.
type	text	Gets or sets the type of the resource.
uuid	text	field from the properties object
v_center_id	text	field from the properties object

resource_pools

Name	Datatype	Description
id	string	Gets or sets the Id.
name	string	Gets or sets the name.
extendedLocation	object	The extended location.
kind	string	Metadata used by portal/tooling/etc to render different UX experiences for resources of the same type; e.g. ApiApps are a kind of Microsoft.Web/sites type. If supported, the resource provider must validate and persist this value.
location	string	Gets or sets the location.
properties	object	Describes the properties of a Resource Pool.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Gets or sets the Resource tags.
type	string	Gets or sets the type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourcePoolName, subscriptionId	Implements resourcePool GET method.
list	SELECT	subscriptionId	List of resourcePools in a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List of resourcePools in a resource group.
create	INSERT	resourceGroupName, resourcePoolName, subscriptionId, data__location, data__properties	Create Or Update resourcePool.
delete	DELETE	resourceGroupName, resourcePoolName, subscriptionId	Implements resourcePool DELETE method.
update	UPDATE	resourceGroupName, resourcePoolName, subscriptionId	API to update certain properties of the resourcePool resource.

SELECT examples

List of resourcePools in a subscription.

vw_resource_pools

SELECT
id,
name,
cpu_capacity_m_hz,
cpu_limit_m_hz,
cpu_overall_usage_m_hz,
cpu_reservation_m_hz,
cpu_shares_level,
custom_resource_name,
datastore_ids,
extended_location,
inventory_item_id,
kind,
location,
mem_capacity_gb,
mem_limit_mb,
mem_overall_usage_gb,
mem_reservation_mb,
mem_shares_level,
mo_name,
mo_ref_id,
network_ids,
provisioning_state,
resourceGroupName,
resourcePoolName,
statuses,
subscriptionId,
system_data,
tags,
type,
uuid,
v_center_id
FROM azure_isv.connected_vsphere.vw_resource_pools
WHERE subscriptionId = '{{ subscriptionId }}';

resource_pools

SELECT
id,
name,
extendedLocation,
kind,
location,
properties,
systemData,
tags,
type
FROM azure_isv.connected_vsphere.resource_pools
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.connected_vsphere.resource_pools (
resourceGroupName,
resourcePoolName,
subscriptionId,
data__location,
data__properties,
properties,
location,
extendedLocation,
systemData,
tags,
kind
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourcePoolName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ location }}',
'{{ extendedLocation }}',
'{{ systemData }}',
'{{ tags }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: uuid
          value: string
        - name: vCenterId
          value: string
        - name: moRefId
          value: string
        - name: inventoryItemId
          value: string
        - name: moName
          value: string
        - name: cpuSharesLevel
          value: string
        - name: cpuReservationMHz
          value: integer
        - name: cpuLimitMHz
          value: integer
        - name: memSharesLevel
          value: string
        - name: memReservationMB
          value: integer
        - name: memLimitMB
          value: integer
        - name: memOverallUsageGB
          value: integer
        - name: memCapacityGB
          value: integer
        - name: cpuOverallUsageMHz
          value: integer
        - name: cpuCapacityMHz
          value: integer
        - name: customResourceName
          value: string
        - name: datastoreIds
          value:
            - string
        - name: networkIds
          value:
            - string
        - name: statuses
          value:
            - - name: type
                value: string
              - name: status
                value: string
              - name: reason
                value: string
              - name: message
                value: string
              - name: severity
                value: string
              - name: lastUpdatedAt
                value: string
        - name: provisioningState
          value: []
    - name: location
      value: string
    - name: extendedLocation
      value:
        - name: type
          value: string
        - name: name
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: tags
      value: object
    - name: name
      value: string
    - name: id
      value: string
    - name: type
      value: string
    - name: kind
      value: string

UPDATE example

Updates a resource_pools resource.

/*+ update */
UPDATE azure_isv.connected_vsphere.resource_pools
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourcePoolName = '{{ resourcePoolName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified resource_pools resource.

/*+ delete */
DELETE FROM azure_isv.connected_vsphere.resource_pools
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourcePoolName = '{{ resourcePoolName }}'
AND subscriptionId = '{{ subscriptionId }}';