dev_ops_policy_assignments

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

Overview

Name	dev_ops_policy_assignments
Type	Resource
Id	azure.security.dev_ops_policy_assignments

Fields

vw_dev_ops_policy_assignments

Name	Datatype	Description
assigned_at	text	field from the properties object
descendant_behavior	text	field from the properties object
policy	text	field from the properties object
policyAssignmentId	text	field from the properties object
provisioning_state	text	field from the properties object
provisioning_status_message	text	field from the properties object
provisioning_status_update_time_utc	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceId	text	field from the properties object
resource_id	text	field from the properties object
securityConnectorName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

dev_ops_policy_assignments

Name	Datatype	Description
properties	object	Properties of the DevOps policy assignment resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	policyAssignmentId, resourceGroupName, securityConnectorName, subscriptionId
list	SELECT	resourceGroupName, resourceId, securityConnectorName, subscriptionId
create_or_update	INSERT	policyAssignmentId, resourceGroupName, securityConnectorName, subscriptionId
delete	DELETE	policyAssignmentId, resourceGroupName, securityConnectorName, subscriptionId
update	UPDATE	policyAssignmentId, resourceGroupName, securityConnectorName, subscriptionId

SELECT examples

vw_dev_ops_policy_assignments

SELECT
assigned_at,
descendant_behavior,
policy,
policyAssignmentId,
provisioning_state,
provisioning_status_message,
provisioning_status_update_time_utc,
resourceGroupName,
resourceId,
resource_id,
securityConnectorName,
subscriptionId,
system_data
FROM azure.security.vw_dev_ops_policy_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceId = '{{ resourceId }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

dev_ops_policy_assignments

SELECT
properties,
systemData
FROM azure.security.dev_ops_policy_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceId = '{{ resourceId }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.dev_ops_policy_assignments (
policyAssignmentId,
resourceGroupName,
securityConnectorName,
subscriptionId,
systemData,
properties
)
SELECT 
'{{ policyAssignmentId }}',
'{{ resourceGroupName }}',
'{{ securityConnectorName }}',
'{{ subscriptionId }}',
'{{ systemData }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - 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: provisioningStatusMessage
          value: string
        - name: provisioningStatusUpdateTimeUtc
          value: string
        - name: provisioningState
          value: []
        - name: resourceId
          value: string
        - name: descendantBehavior
          value: []
        - name: policy
          value:
            - name: policyName
              value: string
            - name: policyId
              value: string
            - name: policyVersion
              value: string
            - name: policyType
              value: []
        - name: assignedAt
          value: string

UPDATE example

Updates a dev_ops_policy_assignments resource.

/*+ update */
UPDATE azure.security.dev_ops_policy_assignments
SET 
systemData = '{{ systemData }}',
properties = '{{ properties }}'
WHERE 
policyAssignmentId = '{{ policyAssignmentId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified dev_ops_policy_assignments resource.

/*+ delete */
DELETE FROM azure.security.dev_ops_policy_assignments
WHERE policyAssignmentId = '{{ policyAssignmentId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';