plan_members

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

Overview

Name	plan_members
Type	Resource
Id	azure.dev_center.plan_members

Fields

vw_plan_members

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
memberName	text	field from the properties object
member_id	text	field from the properties object
member_type	text	field from the properties object
planName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
sync_status	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

plan_members

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	Properties of the devcenter plan member.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	memberName, planName, resourceGroupName, subscriptionId	Gets a devcenter plan member.
list	SELECT	planName, resourceGroupName, subscriptionId	Lists all of the members assigned to a devcenter plan.
create_or_update	INSERT	memberName, planName, resourceGroupName, subscriptionId	Creates or updates a devcenter plan member resource
delete	DELETE	memberName, planName, resourceGroupName, subscriptionId	Deletes a devcenter plan member
update	UPDATE	memberName, planName, resourceGroupName, subscriptionId	Partially updates a devcenter plan member.

SELECT examples

Lists all of the members assigned to a devcenter plan.

vw_plan_members

SELECT
id,
name,
memberName,
member_id,
member_type,
planName,
provisioning_state,
resourceGroupName,
subscriptionId,
sync_status,
system_data,
tags,
type
FROM azure.dev_center.vw_plan_members
WHERE planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

plan_members

SELECT
id,
name,
properties,
systemData,
tags,
type
FROM azure.dev_center.plan_members
WHERE planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.plan_members (
memberName,
planName,
resourceGroupName,
subscriptionId,
properties,
tags
)
SELECT 
'{{ memberName }}',
'{{ planName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - 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: properties
      value:
        - name: memberId
          value: string
        - name: memberType
          value: string
        - name: syncStatus
          value:
            - name: syncState
              value: string
            - name: lastSyncError
              value:
                - name: code
                  value: string
                - name: message
                  value: string
                - name: target
                  value: string
                - name: details
                  value:
                    - - name: code
                        value: string
                      - name: message
                        value: string
                      - name: target
                        value: string
                      - name: details
                        value:
                          - - name: code
                              value: string
                            - name: message
                              value: string
                            - name: target
                              value: string
                            - name: details
                              value:
                                - - name: code
                                    value: string
                                  - name: message
                                    value: string
                                  - name: target
                                    value: string
                                  - name: details
                                    value:
                                      - - name: code
                                          value: string
                                        - name: message
                                          value: string
                                        - name: target
                                          value: string
                                        - name: details
                                          value:
                                            - - name: code
                                                value: string
                                              - name: message
                                                value: string
                                              - name: target
                                                value: string
                                              - name: details
                                                value:
                                                  - - name: code
                                                      value: string
                                                    - name: message
                                                      value: string
                                                    - name: target
                                                      value: string
                                                    - name: details
                                                      value:
                                                        - - name: code
                                                            value: string
                                                          - name: message
                                                            value: string
                                                          - name: target
                                                            value: string
                                                          - name: details
                                                            value:
                                                              - []
                                                          - name: additionalInfo
                                                            value:
                                                              - []
                                                    - name: additionalInfo
                                                      value:
                                                        - - name: type
                                                            value: string
                                                          - name: info
                                                            value: object
                                              - name: additionalInfo
                                                value:
                                                  - - name: type
                                                      value: string
                                                    - name: info
                                                      value: object
                                        - name: additionalInfo
                                          value:
                                            - - name: type
                                                value: string
                                              - name: info
                                                value: object
                                  - name: additionalInfo
                                    value:
                                      - - name: type
                                          value: string
                                        - name: info
                                          value: object
                            - name: additionalInfo
                              value:
                                - - name: type
                                    value: string
                                  - name: info
                                    value: object
                      - name: additionalInfo
                        value:
                          - - name: type
                              value: string
                            - name: info
                              value: object
                - name: additionalInfo
                  value:
                    - - name: type
                        value: string
                      - name: info
                        value: object
            - name: lastSyncTime
              value: string
        - name: tags
          value: []
        - name: provisioningState
          value: []

UPDATE example

Updates a plan_members resource.

/*+ update */
UPDATE azure.dev_center.plan_members
SET 
tags = '{{ tags }}'
WHERE 
memberName = '{{ memberName }}'
AND planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified plan_members resource.

/*+ delete */
DELETE FROM azure.dev_center.plan_members
WHERE memberName = '{{ memberName }}'
AND planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';