network_connections

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

Overview

Name	network_connections
Type	Resource
Id	azure.dev_center.network_connections

Fields

vw_network_connections

Name	Datatype	Description
domain_join_type	text	field from the properties object
domain_name	text	field from the properties object
domain_password	text	field from the properties object
domain_username	text	field from the properties object
health_check_status	text	field from the properties object
location	text	The geo-location where the resource lives
networkConnectionName	text	field from the properties object
networking_resource_group_name	text	field from the properties object
organization_unit	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subnet_id	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

network_connections

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	networkConnectionName, resourceGroupName, subscriptionId	Gets a network connection resource
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists network connections in a resource group
list_by_subscription	SELECT	subscriptionId	Lists network connections in a subscription
create_or_update	INSERT	networkConnectionName, resourceGroupName, subscriptionId	Creates or updates a Network Connections resource
delete	DELETE	networkConnectionName, resourceGroupName, subscriptionId	Deletes a Network Connections resource
update	UPDATE	networkConnectionName, resourceGroupName, subscriptionId	Partially updates a Network Connection
run_health_checks	EXEC	networkConnectionName, resourceGroupName, subscriptionId	Triggers a new health check run. The execution and health check result can be tracked via the network Connection health check details

SELECT examples

Lists network connections in a subscription

vw_network_connections

SELECT
domain_join_type,
domain_name,
domain_password,
domain_username,
health_check_status,
location,
networkConnectionName,
networking_resource_group_name,
organization_unit,
provisioning_state,
resourceGroupName,
subnet_id,
subscriptionId,
tags
FROM azure.dev_center.vw_network_connections
WHERE subscriptionId = '{{ subscriptionId }}';

network_connections

SELECT
location,
properties,
tags
FROM azure.dev_center.network_connections
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.network_connections (
networkConnectionName,
resourceGroupName,
subscriptionId,
tags,
location,
properties
)
SELECT 
'{{ networkConnectionName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: subnetId
          value: string
        - name: domainName
          value: string
        - name: organizationUnit
          value: string
        - name: domainUsername
          value: string
        - name: domainPassword
          value: string
        - name: provisioningState
          value: []
        - name: healthCheckStatus
          value: []
        - name: networkingResourceGroupName
          value: string
        - name: domainJoinType
          value: []

UPDATE example

Updates a network_connections resource.

/*+ update */
UPDATE azure.dev_center.network_connections
SET 
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE 
networkConnectionName = '{{ networkConnectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified network_connections resource.

/*+ delete */
DELETE FROM azure.dev_center.network_connections
WHERE networkConnectionName = '{{ networkConnectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';