virtual_network_addresses

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

Overview

Name	virtual_network_addresses
Type	Resource
Id	azure_isv.oracle.virtual_network_addresses

Fields

vw_virtual_network_addresses

Name	Datatype	Description
cloudvmclustername	text	field from the properties object
domain	text	field from the properties object
ip_address	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
ocid	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
time_assigned	text	field from the properties object
virtualnetworkaddressname	text	field from the properties object
vm_ocid	text	field from the properties object

virtual_network_addresses

Name	Datatype	Description
properties	object	virtualNetworkAddress resource properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudvmclustername, resourceGroupName, subscriptionId, virtualnetworkaddressname	Get a VirtualNetworkAddress
list_by_cloud_vm_cluster	SELECT	cloudvmclustername, resourceGroupName, subscriptionId	List VirtualNetworkAddress resources by CloudVmCluster
create_or_update	INSERT	cloudvmclustername, resourceGroupName, subscriptionId, virtualnetworkaddressname	Create a VirtualNetworkAddress
delete	DELETE	cloudvmclustername, resourceGroupName, subscriptionId, virtualnetworkaddressname	Delete a VirtualNetworkAddress

SELECT examples

List VirtualNetworkAddress resources by CloudVmCluster

vw_virtual_network_addresses

SELECT
cloudvmclustername,
domain,
ip_address,
lifecycle_details,
lifecycle_state,
ocid,
provisioning_state,
resourceGroupName,
subscriptionId,
time_assigned,
virtualnetworkaddressname,
vm_ocid
FROM azure_isv.oracle.vw_virtual_network_addresses
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

virtual_network_addresses

SELECT
properties
FROM azure_isv.oracle.virtual_network_addresses
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.oracle.virtual_network_addresses (
cloudvmclustername,
resourceGroupName,
subscriptionId,
virtualnetworkaddressname,
properties
)
SELECT 
'{{ cloudvmclustername }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ virtualnetworkaddressname }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: ipAddress
          value: string
        - name: vmOcid
          value: []
        - name: domain
          value: string
        - name: lifecycleDetails
          value: string
        - name: provisioningState
          value: []
        - name: lifecycleState
          value: []
        - name: timeAssigned
          value: string

DELETE example

Deletes the specified virtual_network_addresses resource.

/*+ delete */
DELETE FROM azure_isv.oracle.virtual_network_addresses
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND virtualnetworkaddressname = '{{ virtualnetworkaddressname }}';