sites

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

Overview

Name	sites
Type	Resource
Id	azure.hybrid_network.sites

Fields

vw_sites

Name	Datatype	Description
location	text	The geo-location where the resource lives
nfvis	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
site_network_service_references	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

sites

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Site properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, subscriptionId	Gets information about the specified network site.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all sites in the network service.
list_by_subscription	SELECT	subscriptionId	Lists all sites in the network service in a subscription.
create_or_update	INSERT	resourceGroupName, siteName, subscriptionId	Creates or updates a network site.
delete	DELETE	resourceGroupName, siteName, subscriptionId	Deletes the specified network site.
update_tags	EXEC	resourceGroupName, siteName, subscriptionId	Updates a site update tags.

SELECT examples

Lists all sites in the network service in a subscription.

vw_sites

SELECT
location,
nfvis,
provisioning_state,
resourceGroupName,
siteName,
site_network_service_references,
subscriptionId,
tags
FROM azure.hybrid_network.vw_sites
WHERE subscriptionId = '{{ subscriptionId }}';

sites

SELECT
location,
properties,
tags
FROM azure.hybrid_network.sites
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.hybrid_network.sites (
resourceGroupName,
siteName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ siteName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: nfvis
          value:
            - - name: name
                value: string
              - name: nfviType
                value: []
        - name: siteNetworkServiceReferences
          value:
            - - name: id
                value: string
    - name: tags
      value: object
    - name: location
      value: string

DELETE example

Deletes the specified sites resource.

/*+ delete */
DELETE FROM azure.hybrid_network.sites
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';