Skip to main content

sites

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

Overview

Namesites
TypeResource
Idazure_extras.hybrid_network.sites

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
locationstringThe geo-location where the resource lives. Required.
nfvisarrayList of NFVIs.
provisioningStatestringThe provisioning state of the site resource. TODO\ : Confirm if this is needed. Known values are: "Unknown", "Succeeded", "Accepted", "Deleting", "Failed", "Canceled", "Deleted", and "Converging".
siteNetworkServiceReferencesarrayThe list of site network services on the site.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, site_name, subscription_idGets information about the specified network site.
list_by_resource_groupselectresource_group_name, subscription_idLists all sites in the network service.
list_by_subscriptionselectsubscription_idLists all sites in the network service in a subscription.
create_or_updateinsertresource_group_name, site_name, subscription_id, locationCreates or updates a network site.
update_tagsupdateresource_group_name, site_name, subscription_idUpdates a site update tags.
create_or_updatereplaceresource_group_name, site_name, subscription_id, locationCreates or updates a network site.
deletedeleteresource_group_name, site_name, subscription_idDeletes the specified network site.

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.
site_namestringThe name of the network service site. Required.
subscription_idstring

SELECT examples

Gets information about the specified network site.

SELECT
id,
name,
location,
nfvis,
provisioningState,
siteNetworkServiceReferences,
systemData,
tags,
type
FROM azure_extras.hybrid_network.sites
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND site_name = '{{ site_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates a network site.

INSERT INTO azure_extras.hybrid_network.sites (
tags,
location,
properties,
resource_group_name,
site_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ site_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Updates a site update tags.

UPDATE azure_extras.hybrid_network.sites
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND site_name = '{{ site_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Creates or updates a network site.

REPLACE azure_extras.hybrid_network.sites
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND site_name = '{{ site_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Deletes the specified network site.

DELETE FROM azure_extras.hybrid_network.sites
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND site_name = '{{ site_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;