Skip to main content

virtual_network_addresses

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

Overview

Namevirtual_network_addresses
TypeResource
Idazure_isv.oracle.virtual_network_addresses

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, cloudvmclustername, virtualnetworkaddressnameGet a VirtualNetworkAddress
list_by_cloud_vm_clusterselectsubscriptionId, resourceGroupName, cloudvmclusternameList VirtualNetworkAddress resources by CloudVmCluster
create_or_updateinsertsubscriptionId, resourceGroupName, cloudvmclustername, virtualnetworkaddressnameCreate a VirtualNetworkAddress
deletedeletesubscriptionId, resourceGroupName, cloudvmclustername, virtualnetworkaddressnameDelete 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.

NameDatatypeDescription
cloudvmclusternamestringCloudVmCluster name
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
virtualnetworkaddressnamestringVirtual IP address hostname.

SELECT examples

Get a VirtualNetworkAddress

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

INSERT examples

Create a VirtualNetworkAddress

INSERT INTO azure_isv.oracle.virtual_network_addresses (
data__properties,
subscriptionId,
resourceGroupName,
cloudvmclustername,
virtualnetworkaddressname
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ cloudvmclustername }}',
'{{ virtualnetworkaddressname }}'
RETURNING
properties
;

DELETE examples

Delete a VirtualNetworkAddress

DELETE FROM azure_isv.oracle.virtual_network_addresses
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND virtualnetworkaddressname = '{{ virtualnetworkaddressname }}' --required
;