Skip to main content

vw_access_review_instance_my_decisions

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

Overview​

Namevw_access_review_instance_my_decisions
TypeView
Idazure.authorization.vw_access_review_instance_my_decisions

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.principal') as "principal",
JSON_EXTRACT(properties, '$.resource') as "resource",
JSON_EXTRACT(properties, '$.recommendation') as "recommendation",
JSON_EXTRACT(properties, '$.decision') as "decision",
JSON_EXTRACT(properties, '$.justification') as "justification",
JSON_EXTRACT(properties, '$.reviewedDateTime') as "reviewed_date_time",
JSON_EXTRACT(properties, '$.reviewedBy') as "reviewed_by",
JSON_EXTRACT(properties, '$.applyResult') as "apply_result",
JSON_EXTRACT(properties, '$.appliedDateTime') as "applied_date_time",
JSON_EXTRACT(properties, '$.appliedBy') as "applied_by",
JSON_EXTRACT(properties, '$.insights') as "insights",
JSON_EXTRACT(properties, '$.principalResourceMembership') as "principal_resource_membership",
scheduleDefinitionId,
id,
decisionId
FROM azure.authorization.access_review_instance_my_decisions
WHERE scheduleDefinitionId = 'replace-me' AND id = 'replace-me';