access_review_instances

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

Overview

Name	access_review_instances
Type	Resource
Id	azure.authorization.access_review_instances

Fields

vw_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
start_date_time	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The resource type.

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, subscriptionId	Get access review instances
list	SELECT	scheduleDefinitionId, subscriptionId	Get access review instances
create	INSERT	id, scheduleDefinitionId, subscriptionId	Update access review instance.
accept_recommendations	EXEC	id, scheduleDefinitionId	An action to accept recommendations for decision in an access review instance.
apply_decisions	EXEC	id, scheduleDefinitionId, subscriptionId	An action to apply all decisions for an access review instance.
reset_decisions	EXEC	id, scheduleDefinitionId, subscriptionId	An action to reset all decisions for an access review instance.
send_reminders	EXEC	id, scheduleDefinitionId, subscriptionId	An action to send reminders for an access review instance.
stop	EXEC	id, scheduleDefinitionId, subscriptionId	An action to stop an access review instance.

SELECT examples

Get access review instances

vw_access_review_instances

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

access_review_instances

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.authorization.access_review_instances (
id,
scheduleDefinitionId,
subscriptionId,
startDateTime,
endDateTime,
reviewers,
backupReviewers
)
SELECT 
'{{ id }}',
'{{ scheduleDefinitionId }}',
'{{ subscriptionId }}',
'{{ 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