scope_access_review_instances

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

Overview

Name	scope_access_review_instances
Type	Resource
Id	azure.authorization.scope_access_review_instances

Fields

vw_scope_access_review_instances

Name	Datatype	Description
id	text	The access review instance id.
name	text	The access review instance name.
backup_reviewers	text	field from the properties object
end_date_time	text	field from the properties object
reviewers	text	field from the properties object
reviewers_type	text	field from the properties object
scheduleDefinitionId	text	field from the properties object
scope	text	field from the properties object
start_date_time	text	field from the properties object
status	text	field from the properties object
type	text	The resource type.

scope_access_review_instances

Name	Datatype	Description
id	string	The access review instance id.
name	string	The access review instance name.
properties	object	Access Review Instance properties.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get_by_id	SELECT	id, scheduleDefinitionId, scope	Get access review instances
list	SELECT	scheduleDefinitionId, scope	Get access review instances
create	INSERT	id, scheduleDefinitionId, scope	Update access review instance.
apply_decisions	EXEC	id, scheduleDefinitionId, scope	An action to apply all decisions for an access review instance.
record_all_decisions	EXEC	id, scheduleDefinitionId, scope	An action to approve/deny all decisions for a review with certain filters.
reset_decisions	EXEC	id, scheduleDefinitionId, scope	An action to reset all decisions for an access review instance.
send_reminders	EXEC	id, scheduleDefinitionId, scope	An action to send reminders for an access review instance.
stop	EXEC	id, scheduleDefinitionId, scope	An action to stop an access review instance.

SELECT examples

Get access review instances

vw_scope_access_review_instances

SELECT
id,
name,
backup_reviewers,
end_date_time,
reviewers,
reviewers_type,
scheduleDefinitionId,
scope,
start_date_time,
status,
type
FROM azure.authorization.vw_scope_access_review_instances
WHERE scheduleDefinitionId = '{{ scheduleDefinitionId }}'
AND scope = '{{ scope }}';

scope_access_review_instances

SELECT
id,
name,
properties,
type
FROM azure.authorization.scope_access_review_instances
WHERE scheduleDefinitionId = '{{ scheduleDefinitionId }}'
AND scope = '{{ scope }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.authorization.scope_access_review_instances (
id,
scheduleDefinitionId,
scope,
startDateTime,
endDateTime,
reviewers,
backupReviewers
)
SELECT 
'{{ id }}',
'{{ scheduleDefinitionId }}',
'{{ scope }}',
'{{ startDateTime }}',
'{{ endDateTime }}',
'{{ reviewers }}',
'{{ backupReviewers }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: status
      value: string
    - name: startDateTime
      value: string
    - name: endDateTime
      value: string
    - name: reviewers
      value:
        - - name: principalId
            value: string
          - name: principalType
            value: string
    - name: backupReviewers
      value:
        - - name: principalId
            value: string
          - name: principalType
            value: string
    - name: reviewersType
      value: string