task_assignments

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

Overview

Name	task_assignments
Type	Resource
Id	azure.storage.task_assignments

Fields

vw_task_assignments

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
description	text	field from the properties object
accountName	text	field from the properties object
enabled	text	field from the properties object
execution_context	text	field from the properties object
provisioning_state	text	field from the properties object
report	text	field from the properties object
resourceGroupName	text	field from the properties object
run_status	text	field from the properties object
storageTaskAssignmentName	text	field from the properties object
subscriptionId	text	field from the properties object
task_id	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

task_assignments

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Properties of the storage task assignment.
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	accountName, resourceGroupName, storageTaskAssignmentName, subscriptionId	Get the storage task assignment properties
list	SELECT	accountName, resourceGroupName, subscriptionId	List all the storage task assignments in an account
create	INSERT	accountName, resourceGroupName, storageTaskAssignmentName, subscriptionId, data__properties	Asynchronously creates a new storage task assignment sub-resource with the specified parameters. If a storage task assignment is already created and a subsequent create request is issued with different properties, the storage task assignment properties will be updated. If a storage task assignment is already created and a subsequent create or update request is issued with the exact same set of properties, the request will succeed.
delete	DELETE	accountName, resourceGroupName, storageTaskAssignmentName, subscriptionId	Delete the storage task assignment sub-resource
update	UPDATE	accountName, resourceGroupName, storageTaskAssignmentName, subscriptionId	Update storage task assignment properties

SELECT examples

List all the storage task assignments in an account

vw_task_assignments

SELECT
id,
name,
description,
accountName,
enabled,
execution_context,
provisioning_state,
report,
resourceGroupName,
run_status,
storageTaskAssignmentName,
subscriptionId,
task_id,
type
FROM azure.storage.vw_task_assignments
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

task_assignments

SELECT
id,
name,
properties,
type
FROM azure.storage.task_assignments
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.storage.task_assignments (
accountName,
resourceGroupName,
storageTaskAssignmentName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ storageTaskAssignmentName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: taskId
          value: string
        - name: enabled
          value: boolean
        - name: description
          value: string
        - name: executionContext
          value:
            - name: target
              value:
                - name: prefix
                  value:
                    - string
                - name: excludePrefix
                  value:
                    - string
            - name: trigger
              value:
                - name: type
                  value: string
                - name: parameters
                  value:
                    - name: startFrom
                      value: string
                    - name: interval
                      value: integer
                    - name: intervalUnit
                      value: string
                    - name: endBy
                      value: string
                    - name: startOn
                      value: string
        - name: report
          value:
            - name: prefix
              value: string
        - name: provisioningState
          value: string
        - name: runStatus
          value:
            - name: taskAssignmentId
              value: string
            - name: storageAccountId
              value: string
            - name: startTime
              value: string
            - name: finishTime
              value: string
            - name: objectsTargetedCount
              value: string
            - name: objectsOperatedOnCount
              value: string
            - name: objectFailedCount
              value: string
            - name: objectsSucceededCount
              value: string
            - name: runStatusError
              value: string
            - name: runStatusEnum
              value: string
            - name: summaryReportPath
              value: string
            - name: taskId
              value: string
            - name: taskVersion
              value: string
            - name: runResult
              value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a task_assignments resource.

/*+ update */
UPDATE azure.storage.task_assignments
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageTaskAssignmentName = '{{ storageTaskAssignmentName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified task_assignments resource.

/*+ delete */
DELETE FROM azure.storage.task_assignments
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageTaskAssignmentName = '{{ storageTaskAssignmentName }}'
AND subscriptionId = '{{ subscriptionId }}';