Skip to main content

virtual_network_appliances

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

Overview

Namevirtual_network_appliances
TypeResource
Idazure.network.virtual_network_appliances

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringResource name.
bandwidthInGbpsnumberBandwidth of the VirtualNetworkAppliance resource in Gbps.
etagstringA unique read-only string that changes whenever the resource is updated.
ipConfigurationsarrayA list of IPConfigurations of the virtual network appliance.
locationstringResource location.
privateIPAddressVersionstringWhether the specific virtual network appliance is IPv4 or Dual Stack. Default is IPv4. Known values are: "IPv4" and "DualStack". (IPv4, DualStack)
provisioningStatestringThe provisioning state of the virtual network appliance resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
resourceGuidstringThe resource GUID property of the virtual network appliance resource.
subnetobjectSubnet in a virtual network resource.
tagsobjectResource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, virtual_network_appliance_name, subscription_idGets information about the specified virtual network appliance.
listselectresource_group_name, subscription_idGets all virtual network appliances in a resource group.
list_allselectsubscription_idGets all virtual network appliances in a subscription.
create_or_updateinsertresource_group_name, virtual_network_appliance_name, subscription_idCreates or updates a virtual network appliance.
update_tagsupdateresource_group_name, virtual_network_appliance_name, subscription_idUpdates a virtual network appliance tags.
create_or_updatereplaceresource_group_name, virtual_network_appliance_name, subscription_idCreates or updates a virtual network appliance.
deletedeleteresource_group_name, virtual_network_appliance_name, subscription_idDeletes the specified virtual network appliance.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
virtual_network_appliance_namestringThe name of the virtual network appliance. Required.

SELECT examples

Gets information about the specified virtual network appliance.

SELECT
id,
name,
bandwidthInGbps,
etag,
ipConfigurations,
location,
privateIPAddressVersion,
provisioningState,
resourceGuid,
subnet,
tags,
type
FROM azure.network.virtual_network_appliances
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND virtual_network_appliance_name = '{{ virtual_network_appliance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates a virtual network appliance.

INSERT INTO azure.network.virtual_network_appliances (
id,
location,
tags,
properties,
resource_group_name,
virtual_network_appliance_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ virtual_network_appliance_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
location,
properties,
tags,
type
;

UPDATE examples

Updates a virtual network appliance tags.

UPDATE azure.network.virtual_network_appliances
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND virtual_network_appliance_name = '{{ virtual_network_appliance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

REPLACE examples

Creates or updates a virtual network appliance.

REPLACE azure.network.virtual_network_appliances
SET
id = '{{ id }}',
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND virtual_network_appliance_name = '{{ virtual_network_appliance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

DELETE examples

Deletes the specified virtual network appliance.

DELETE FROM azure.network.virtual_network_appliances
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND virtual_network_appliance_name = '{{ virtual_network_appliance_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;