Skip to main content

access_review_instances

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

Overview

Nameaccess_review_instances
TypeResource
Idazure.authorization.access_review_instances

Fields

The following fields are returned by SELECT queries:

Describe the result of a successful operation.

NameDatatypeDescription
idstringThe access review instance id.
namestringThe access review instance name.
propertiesobjectAccess Review properties.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_by_idselectsubscriptionId, scheduleDefinitionId, idGet access review instances
listselectsubscriptionId, scheduleDefinitionId$filterGet access review instances
createinsertsubscriptionId, scheduleDefinitionId, idUpdate access review instance.
stopexecsubscriptionId, scheduleDefinitionId, idAn action to stop an access review instance.
reset_decisionsexecsubscriptionId, scheduleDefinitionId, idAn action to reset all decisions for an access review instance.
apply_decisionsexecsubscriptionId, scheduleDefinitionId, idAn action to apply all decisions for an access review instance.
send_remindersexecsubscriptionId, scheduleDefinitionId, idAn action to send reminders for an access review instance.
accept_recommendationsexecscheduleDefinitionId, idAn action to accept recommendations for decision in an access review instance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
idstringThe id of the access review instance.
scheduleDefinitionIdstringThe id of the access review schedule definition.
subscriptionIdstringThe ID of the target subscription.
$filterstringThe filter to apply on the operation. Other than standard filters, one custom filter option is supported : 'assignedToMeToReview()'. When one specified $filter=assignedToMeToReview(), only items that are assigned to the calling user to review are returned

SELECT examples

Get access review instances

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

INSERT examples

Update access review instance.

INSERT INTO azure.authorization.access_review_instances (
data__startDateTime,
data__endDateTime,
data__reviewers,
data__backupReviewers,
subscriptionId,
scheduleDefinitionId,
id
)
SELECT
'{{ startDateTime }}',
'{{ endDateTime }}',
'{{ reviewers }}',
'{{ backupReviewers }}',
'{{ subscriptionId }}',
'{{ scheduleDefinitionId }}',
'{{ id }}'
RETURNING
id,
name,
properties,
type
;

Lifecycle Methods

An action to stop an access review instance.

EXEC azure.authorization.access_review_instances.stop 
@subscriptionId='{{ subscriptionId }}' --required,
@scheduleDefinitionId='{{ scheduleDefinitionId }}' --required,
@id='{{ id }}' --required
;