virtual_network_addresses

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

Overview

Name	virtual_network_addresses
Type	Resource
Id	azure_isv.oracledatabase.virtual_network_addresses

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
domain	string	Virtual network address fully qualified domain name.
ipAddress	string	Virtual network Address address.
lifecycleDetails	string	Additional information about the current lifecycle state of the application virtual IP (VIP) address.
lifecycleState	string	virtual network address lifecycle state. Known values are: "Provisioning", "Available", "Terminating", "Terminated", and "Failed". (Provisioning, Available, Terminating, Terminated, Failed)
ocid	string	Application VIP OCID.
provisioningState	string	Azure resource provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
timeAssigned	string (date-time)	The date and time when the create operation for the application virtual IP (VIP) address completed.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
vmOcid	string	Virtual Machine OCID.

list_by_parent

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
domain	string	Virtual network address fully qualified domain name.
ipAddress	string	Virtual network Address address.
lifecycleDetails	string	Additional information about the current lifecycle state of the application virtual IP (VIP) address.
lifecycleState	string	virtual network address lifecycle state. Known values are: "Provisioning", "Available", "Terminating", "Terminated", and "Failed". (Provisioning, Available, Terminating, Terminated, Failed)
ocid	string	Application VIP OCID.
provisioningState	string	Azure resource provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
timeAssigned	string (date-time)	The date and time when the create operation for the application virtual IP (VIP) address completed.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
vmOcid	string	Virtual Machine OCID.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, cloudvmclustername, virtualnetworkaddressname, subscription_id		Get a VirtualNetworkAddress.
list_by_parent	select	resource_group_name, cloudvmclustername, subscription_id		List VirtualNetworkAddress resources by CloudVmCluster.
create_or_update	insert	resource_group_name, cloudvmclustername, virtualnetworkaddressname, subscription_id		Create a VirtualNetworkAddress.
create_or_update	replace	resource_group_name, cloudvmclustername, virtualnetworkaddressname, subscription_id		Create a VirtualNetworkAddress.
delete	delete	resource_group_name, cloudvmclustername, virtualnetworkaddressname, subscription_id		Delete a VirtualNetworkAddress.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
cloudvmclustername	string	CloudVmCluster name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
virtualnetworkaddressname	string	Virtual IP address hostname. Required.

SELECT examples

get

Get a VirtualNetworkAddress.

SELECT
id,
name,
domain,
ipAddress,
lifecycleDetails,
lifecycleState,
ocid,
provisioningState,
systemData,
timeAssigned,
type,
vmOcid
FROM azure_isv.oracledatabase.virtual_network_addresses
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cloudvmclustername = '{{ cloudvmclustername }}' -- required
AND virtualnetworkaddressname = '{{ virtualnetworkaddressname }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_parent

List VirtualNetworkAddress resources by CloudVmCluster.

SELECT
id,
name,
domain,
ipAddress,
lifecycleDetails,
lifecycleState,
ocid,
provisioningState,
systemData,
timeAssigned,
type,
vmOcid
FROM azure_isv.oracledatabase.virtual_network_addresses
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cloudvmclustername = '{{ cloudvmclustername }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Create a VirtualNetworkAddress.

INSERT INTO azure_isv.oracledatabase.virtual_network_addresses (
properties,
resource_group_name,
cloudvmclustername,
virtualnetworkaddressname,
subscription_id
)
SELECT 
'{{ properties }}',
'{{ resource_group_name }}',
'{{ cloudvmclustername }}',
'{{ virtualnetworkaddressname }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: virtual_network_addresses
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the virtual_network_addresses resource.
  - name: cloudvmclustername
    value: "{{ cloudvmclustername }}"
    description: Required parameter for the virtual_network_addresses resource.
  - name: virtualnetworkaddressname
    value: "{{ virtualnetworkaddressname }}"
    description: Required parameter for the virtual_network_addresses resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the virtual_network_addresses resource.
  - name: properties
    description: |
      The resource-specific properties for this resource.
    value:
      ipAddress: "{{ ipAddress }}"
      vmOcid: "{{ vmOcid }}"
      ocid: "{{ ocid }}"
      domain: "{{ domain }}"
      lifecycleDetails: "{{ lifecycleDetails }}"
      provisioningState: "{{ provisioningState }}"
      lifecycleState: "{{ lifecycleState }}"
      timeAssigned: "{{ timeAssigned }}"

REPLACE examples

create_or_update

Create a VirtualNetworkAddress.

REPLACE azure_isv.oracledatabase.virtual_network_addresses
SET 
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND virtualnetworkaddressname = '{{ virtualnetworkaddressname }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

delete

Delete a VirtualNetworkAddress.

DELETE FROM azure_isv.oracledatabase.virtual_network_addresses
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND virtualnetworkaddressname = '{{ virtualnetworkaddressname }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;