Skip to main content

scope_access_review_history_definitions

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

Overview

Namescope_access_review_history_definitions
TypeResource
Idazure.authorization.scope_access_review_history_definitions

Fields

The following fields are returned by SELECT queries:

AccessReviewHistoryDefinition

NameDatatypeDescription
idstringThe access review history definition id.
namestringThe access review history definition unique id.
propertiesobjectAccess Review History Definition properties.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_by_idselectscope, historyDefinitionIdGet access review history definition by definition Id
listselectscope$filterLists the accessReviewHistoryDefinitions available from this provider, definition instances are only available for 30 days after creation.
createinsertscope, historyDefinitionIdCreate a scheduled or one-time Access Review History Definition
delete_by_iddeletescope, historyDefinitionIdDelete an access review history definition

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
historyDefinitionIdstringThe id of the access review history definition.
scopestringThe scope of the operation or resource. Valid scopes are: subscription (format: '/subscriptions/{subscriptionId}'), resource group (format: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}', or resource (format: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/[{parentResourcePath}/]{resourceType}/{resourceName}'
$filterstringThe filter to apply on the operation. Only standard filters on definition name and created date are supported

SELECT examples

Get access review history definition by definition Id

SELECT
id,
name,
properties,
type
FROM azure.authorization.scope_access_review_history_definitions
WHERE scope = '{{ scope }}' -- required
AND historyDefinitionId = '{{ historyDefinitionId }}' -- required
;

INSERT examples

Create a scheduled or one-time Access Review History Definition

INSERT INTO azure.authorization.scope_access_review_history_definitions (
data__displayName,
data__decisions,
data__scopes,
data__settings,
data__instances,
scope,
historyDefinitionId
)
SELECT
'{{ displayName }}',
'{{ decisions }}',
'{{ scopes }}',
'{{ settings }}',
'{{ instances }}',
'{{ scope }}',
'{{ historyDefinitionId }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Delete an access review history definition

DELETE FROM azure.authorization.scope_access_review_history_definitions
WHERE scope = '{{ scope }}' --required
AND historyDefinitionId = '{{ historyDefinitionId }}' --required
;