vmm_servers

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

Overview

Name	vmm_servers
Type	Resource
Id	azure.system_center_vm_manager.vmm_servers

Fields

vw_vmm_servers

Name	Datatype	Description
connection_status	text	field from the properties object
credentials	text	field from the properties object
error_message	text	field from the properties object
extended_location	text	field from the properties object
fqdn	text	field from the properties object
location	text	The geo-location where the resource lives
port	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
version	text	field from the properties object
vmmServerName	text	field from the properties object

vmm_servers

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, vmmServerName	Implements VmmServer GET method.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List of VmmServers in a resource group.
list_by_subscription	SELECT	subscriptionId	List of VmmServers in a subscription.
create_or_update	INSERT	resourceGroupName, subscriptionId, vmmServerName, data__extendedLocation	Onboards the SCVmm fabric as an Azure VmmServer resource.
delete	DELETE	resourceGroupName, subscriptionId, vmmServerName	Removes the SCVmm fabric from Azure.
update	UPDATE	resourceGroupName, subscriptionId, vmmServerName	Updates the VmmServers resource.

SELECT examples

List of VmmServers in a subscription.

vw_vmm_servers

SELECT
connection_status,
credentials,
error_message,
extended_location,
fqdn,
location,
port,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
uuid,
version,
vmmServerName
FROM azure.system_center_vm_manager.vw_vmm_servers
WHERE subscriptionId = '{{ subscriptionId }}';

vmm_servers

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: credentials
          value:
            - name: username
              value: string
            - name: password
              value: string
        - name: fqdn
          value: string
        - name: port
          value: integer
        - name: connectionStatus
          value: string
        - name: errorMessage
          value: string
        - name: uuid
          value: string
        - name: version
          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 vmm_servers resource.

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

DELETE example

Deletes the specified vmm_servers resource.

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