virtual_networks

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

Overview

Name	virtual_networks
Type	Resource
Id	azure.system_center_vm_manager.virtual_networks

Fields

vw_virtual_networks

Name	Datatype	Description
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
network_name	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
virtualNetworkName	text	field from the properties object
vmm_server_id	text	field from the properties object

virtual_networks

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

SELECT examples

List of VirtualNetworks in a subscription.

vw_virtual_networks

SELECT
extended_location,
inventory_item_id,
location,
network_name,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
uuid,
virtualNetworkName,
vmm_server_id
FROM azure.system_center_vm_manager.vw_virtual_networks
WHERE subscriptionId = '{{ subscriptionId }}';

virtual_networks

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.system_center_vm_manager.virtual_networks (
resourceGroupName,
subscriptionId,
virtualNetworkName,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ virtualNetworkName }}',
'{{ 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: networkName
          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 virtual_networks resource.

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

DELETE example

Deletes the specified virtual_networks resource.

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