virtual_machine_templates

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

Overview

Name	virtual_machine_templates
Type	Resource
Id	azure.system_center_vm_manager.virtual_machine_templates

Fields

vw_virtual_machine_templates

Name	Datatype	Description
computer_name	text	field from the properties object
cpu_count	text	field from the properties object
disks	text	field from the properties object
dynamic_memory_enabled	text	field from the properties object
dynamic_memory_max_mb	text	field from the properties object
dynamic_memory_min_mb	text	field from the properties object
extended_location	text	field from the properties object
generation	text	field from the properties object
inventory_item_id	text	field from the properties object
is_customizable	text	field from the properties object
is_highly_available	text	field from the properties object
limit_cpu_for_migration	text	field from the properties object
location	text	The geo-location where the resource lives
memory_mb	text	field from the properties object
network_interfaces	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
subscriptionId	text	field from the properties object
tags	text	Resource tags.
uuid	text	field from the properties object
virtualMachineTemplateName	text	field from the properties object
vmm_server_id	text	field from the properties object

virtual_machine_templates

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

SELECT examples

List of VirtualMachineTemplates in a subscription.

vw_virtual_machine_templates

SELECT
computer_name,
cpu_count,
disks,
dynamic_memory_enabled,
dynamic_memory_max_mb,
dynamic_memory_min_mb,
extended_location,
generation,
inventory_item_id,
is_customizable,
is_highly_available,
limit_cpu_for_migration,
location,
memory_mb,
network_interfaces,
os_name,
os_type,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
uuid,
virtualMachineTemplateName,
vmm_server_id
FROM azure.system_center_vm_manager.vw_virtual_machine_templates
WHERE subscriptionId = '{{ subscriptionId }}';

virtual_machine_templates

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.system_center_vm_manager.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.system_center_vm_manager.virtual_machine_templates (
resourceGroupName,
subscriptionId,
virtualMachineTemplateName,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ virtualMachineTemplateName }}',
'{{ 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: osType
          value: []
        - name: osName
          value: string
        - name: computerName
          value: string
        - name: memoryMB
          value: integer
        - name: cpuCount
          value: integer
        - name: limitCpuForMigration
          value: []
        - name: dynamicMemoryEnabled
          value: []
        - name: isCustomizable
          value: []
        - name: dynamicMemoryMaxMB
          value: integer
        - name: dynamicMemoryMinMB
          value: integer
        - name: isHighlyAvailable
          value: []
        - name: generation
          value: integer
        - name: networkInterfaces
          value:
            - - name: name
                value: string
              - name: displayName
                value: string
              - name: ipv4Addresses
                value:
                  - string
              - name: ipv6Addresses
                value:
                  - string
              - name: macAddress
                value: string
              - name: virtualNetworkId
                value: string
              - name: networkName
                value: string
              - name: ipv4AddressType
                value: []
              - name: nicId
                value: string
        - name: disks
          value:
            - - name: name
                value: string
              - name: displayName
                value: string
              - name: diskId
                value: string
              - name: diskSizeGB
                value: integer
              - name: maxDiskSizeGB
                value: integer
              - name: bus
                value: integer
              - name: lun
                value: integer
              - name: busType
                value: string
              - name: vhdType
                value: string
              - name: volumeType
                value: string
              - name: vhdFormatType
                value: string
              - name: templateDiskId
                value: string
              - name: storageQoSPolicy
                value:
                  - name: name
                    value: string
                  - name: id
                    value: string
              - name: createDiffDisk
                value: []
        - 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 virtual_machine_templates resource.

/*+ update */
UPDATE azure.system_center_vm_manager.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.system_center_vm_manager.virtual_machine_templates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND virtualMachineTemplateName = '{{ virtualMachineTemplateName }}';