virtual_machine_templates

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

Overview

Name	virtual_machine_templates
Type	Resource
Id	azure_isv.connected_vsphere.virtual_machine_templates

Fields

vw_virtual_machine_templates

Name	Datatype	Description
id	text	Gets or sets the Id.
name	text	Gets or sets the name.
custom_resource_name	text	field from the properties object
disks	text	field from the properties object
extended_location	text	field from the properties object
firmware_type	text	field from the properties object
folder_path	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.
memory_size_mb	text	field from the properties object
mo_name	text	field from the properties object
mo_ref_id	text	field from the properties object
network_interfaces	text	field from the properties object
num_cores_per_socket	text	field from the properties object
num_cp_us	text	field from the properties object
os_name	text	field from the properties object
os_type	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	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.
tools_version	text	field from the properties object
tools_version_status	text	field from the properties object
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
virtualMachineTemplateName	text	field from the properties object

virtual_machine_templates

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 Virtual Machine Template.
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, subscriptionId, virtualMachineTemplateName	Implements virtual machine template GET method.
list	SELECT	subscriptionId	List of virtualMachineTemplates in a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List of virtualMachineTemplates in a resource group.
create	INSERT	resourceGroupName, subscriptionId, virtualMachineTemplateName, data__location, data__properties	Create Or Update virtual machine template.
delete	DELETE	resourceGroupName, subscriptionId, virtualMachineTemplateName	Implements virtual machine template DELETE method.
update	UPDATE	resourceGroupName, subscriptionId, virtualMachineTemplateName	API to update certain properties of the virtual machine template resource.

SELECT examples

List of virtualMachineTemplates in a subscription.

vw_virtual_machine_templates

SELECT
id,
name,
custom_resource_name,
disks,
extended_location,
firmware_type,
folder_path,
inventory_item_id,
kind,
location,
memory_size_mb,
mo_name,
mo_ref_id,
network_interfaces,
num_cores_per_socket,
num_cp_us,
os_name,
os_type,
provisioning_state,
resourceGroupName,
statuses,
subscriptionId,
system_data,
tags,
tools_version,
tools_version_status,
type,
uuid,
v_center_id,
virtualMachineTemplateName
FROM azure_isv.connected_vsphere.vw_virtual_machine_templates
WHERE subscriptionId = '{{ subscriptionId }}';

virtual_machine_templates

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.connected_vsphere.virtual_machine_templates (
resourceGroupName,
subscriptionId,
virtualMachineTemplateName,
data__location,
data__properties,
properties,
location,
extendedLocation,
systemData,
tags,
kind
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ virtualMachineTemplateName }}',
'{{ 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: memorySizeMB
          value: integer
        - name: numCPUs
          value: integer
        - name: numCoresPerSocket
          value: integer
        - name: osType
          value: []
        - name: osName
          value: string
        - name: folderPath
          value: string
        - name: networkInterfaces
          value:
            - - name: name
                value: string
              - name: label
                value: string
              - name: ipAddresses
                value:
                  - string
              - name: macAddress
                value: string
              - name: networkId
                value: string
              - name: nicType
                value: []
              - name: powerOnBoot
                value: []
              - name: networkMoRefId
                value: string
              - name: networkMoName
                value: string
              - name: deviceKey
                value: integer
              - name: ipSettings
                value:
                  - name: allocationMethod
                    value: []
                  - name: dnsServers
                    value:
                      - string
                  - name: gateway
                    value:
                      - string
                  - name: ipAddress
                    value: string
                  - name: subnetMask
                    value: string
                  - name: primaryWinsServer
                    value: string
                  - name: secondaryWinsServer
                    value: string
                  - name: ipAddressInfo
                    value:
                      - - name: allocationMethod
                          value: string
                        - name: ipAddress
                          value: string
                        - name: subnetMask
                          value: string
        - name: disks
          value:
            - - name: name
                value: string
              - name: label
                value: string
              - name: diskObjectId
                value: string
              - name: diskSizeGB
                value: integer
              - name: deviceKey
                value: integer
              - name: diskMode
                value: []
              - name: controllerKey
                value: integer
              - name: unitNumber
                value: integer
              - name: deviceName
                value: string
              - name: diskType
                value: []
        - name: customResourceName
          value: string
        - name: toolsVersionStatus
          value: string
        - name: toolsVersion
          value: string
        - name: firmwareType
          value: []
        - 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 virtual_machine_templates resource.

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

DELETE example

Deletes the specified virtual_machine_templates resource.

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