static_members

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

Overview

Name	static_members
Type	Resource
Id	azure.network.static_members

Fields

vw_static_members

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
etag	text	A unique read-only string that changes whenever the resource is updated.
networkGroupName	text	field from the properties object
networkManagerName	text	field from the properties object
provisioning_state	text	field from the properties object
region	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_id	text	field from the properties object
staticMemberName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	Resource type.

static_members

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
etag	string	A unique read-only string that changes whenever the resource is updated.
properties	object	Properties of static member.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	networkGroupName, networkManagerName, resourceGroupName, staticMemberName, subscriptionId	Gets the specified static member.
list	SELECT	networkGroupName, networkManagerName, resourceGroupName, subscriptionId	Lists the specified static member.
create_or_update	INSERT	networkGroupName, networkManagerName, resourceGroupName, staticMemberName, subscriptionId	Creates or updates a static member.
delete	DELETE	networkGroupName, networkManagerName, resourceGroupName, staticMemberName, subscriptionId	Deletes a static member.

SELECT examples

Lists the specified static member.

vw_static_members

SELECT
id,
name,
etag,
networkGroupName,
networkManagerName,
provisioning_state,
region,
resourceGroupName,
resource_id,
staticMemberName,
subscriptionId,
system_data,
type
FROM azure.network.vw_static_members
WHERE networkGroupName = '{{ networkGroupName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

static_members

SELECT
id,
name,
etag,
properties,
systemData,
type
FROM azure.network.static_members
WHERE networkGroupName = '{{ networkGroupName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.static_members (
networkGroupName,
networkManagerName,
resourceGroupName,
staticMemberName,
subscriptionId,
properties
)
SELECT 
'{{ networkGroupName }}',
'{{ networkManagerName }}',
'{{ resourceGroupName }}',
'{{ staticMemberName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: resourceId
          value: string
        - name: region
          value: string
        - name: provisioningState
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string

DELETE example

Deletes the specified static_members resource.

/*+ delete */
DELETE FROM azure.network.static_members
WHERE networkGroupName = '{{ networkGroupName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND staticMemberName = '{{ staticMemberName }}'
AND subscriptionId = '{{ subscriptionId }}';