virtual_appliance_sites

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

Overview

Name	virtual_appliance_sites
Type	Resource
Id	azure.network.virtual_appliance_sites

Fields

vw_virtual_appliance_sites

Name	Datatype	Description
id	text	Resource ID.
name	text	Name of the virtual appliance site.
address_prefix	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
networkVirtualApplianceName	text	field from the properties object
o365_policy	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
siteName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Site type.

virtual_appliance_sites

Name	Datatype	Description
id	string	Resource ID.
name	string	Name of the virtual appliance site.
etag	string	A unique read-only string that changes whenever the resource is updated.
properties	object	Properties of the rule group.
type	string	Site type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	networkVirtualApplianceName, resourceGroupName, siteName, subscriptionId	Gets the specified Virtual Appliance Site.
list	SELECT	networkVirtualApplianceName, resourceGroupName, subscriptionId	Lists all Network Virtual Appliance Sites in a Network Virtual Appliance resource.
create_or_update	INSERT	networkVirtualApplianceName, resourceGroupName, siteName, subscriptionId	Creates or updates the specified Network Virtual Appliance Site.
delete	DELETE	networkVirtualApplianceName, resourceGroupName, siteName, subscriptionId	Deletes the specified site from a Virtual Appliance.

SELECT examples

Lists all Network Virtual Appliance Sites in a Network Virtual Appliance resource.

vw_virtual_appliance_sites

SELECT
id,
name,
address_prefix,
etag,
networkVirtualApplianceName,
o365_policy,
provisioning_state,
resourceGroupName,
siteName,
subscriptionId,
type
FROM azure.network.vw_virtual_appliance_sites
WHERE networkVirtualApplianceName = '{{ networkVirtualApplianceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

virtual_appliance_sites

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.virtual_appliance_sites
WHERE networkVirtualApplianceName = '{{ networkVirtualApplianceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.virtual_appliance_sites (
networkVirtualApplianceName,
resourceGroupName,
siteName,
subscriptionId,
properties,
name,
id
)
SELECT 
'{{ networkVirtualApplianceName }}',
'{{ resourceGroupName }}',
'{{ siteName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ name }}',
'{{ id }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: addressPrefix
          value: string
        - name: o365Policy
          value:
            - name: breakOutCategories
              value:
                - name: allow
                  value: boolean
                - name: optimize
                  value: boolean
                - name: default
                  value: boolean
        - name: provisioningState
          value: []
    - name: name
      value: string
    - name: etag
      value: string
    - name: type
      value: string
    - name: id
      value: string

DELETE example

Deletes the specified virtual_appliance_sites resource.

/*+ delete */
DELETE FROM azure.network.virtual_appliance_sites
WHERE networkVirtualApplianceName = '{{ networkVirtualApplianceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';