vw_role_assignment_schedule_instances

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

Overview

Name	vw_role_assignment_schedule_instances
Type	View
Id	azure.authorization.vw_role_assignment_schedule_instances

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.scope') as "scope",
JSON_EXTRACT(properties, '$.roleDefinitionId') as "role_definition_id",
JSON_EXTRACT(properties, '$.principalId') as "principal_id",
JSON_EXTRACT(properties, '$.principalType') as "principal_type",
JSON_EXTRACT(properties, '$.roleAssignmentScheduleId') as "role_assignment_schedule_id",
JSON_EXTRACT(properties, '$.originRoleAssignmentId') as "origin_role_assignment_id",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.startDateTime') as "start_date_time",
JSON_EXTRACT(properties, '$.endDateTime') as "end_date_time",
JSON_EXTRACT(properties, '$.linkedRoleEligibilityScheduleId') as "linked_role_eligibility_schedule_id",
JSON_EXTRACT(properties, '$.linkedRoleEligibilityScheduleInstanceId') as "linked_role_eligibility_schedule_instance_id",
JSON_EXTRACT(properties, '$.assignmentType') as "assignment_type",
JSON_EXTRACT(properties, '$.memberType') as "member_type",
JSON_EXTRACT(properties, '$.condition') as "condition",
JSON_EXTRACT(properties, '$.conditionVersion') as "condition_version",
JSON_EXTRACT(properties, '$.createdOn') as "created_on",
JSON_EXTRACT(properties, '$.expandedProperties') as "expanded_properties",
scope,
roleAssignmentScheduleInstanceName
FROM azure.authorization.role_assignment_schedule_instances
WHERE scope = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
json_extract_path_text(properties, '$.scope') as "scope",
json_extract_path_text(properties, '$.roleDefinitionId') as "role_definition_id",
json_extract_path_text(properties, '$.principalId') as "principal_id",
json_extract_path_text(properties, '$.principalType') as "principal_type",
json_extract_path_text(properties, '$.roleAssignmentScheduleId') as "role_assignment_schedule_id",
json_extract_path_text(properties, '$.originRoleAssignmentId') as "origin_role_assignment_id",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.startDateTime') as "start_date_time",
json_extract_path_text(properties, '$.endDateTime') as "end_date_time",
json_extract_path_text(properties, '$.linkedRoleEligibilityScheduleId') as "linked_role_eligibility_schedule_id",
json_extract_path_text(properties, '$.linkedRoleEligibilityScheduleInstanceId') as "linked_role_eligibility_schedule_instance_id",
json_extract_path_text(properties, '$.assignmentType') as "assignment_type",
json_extract_path_text(properties, '$.memberType') as "member_type",
json_extract_path_text(properties, '$.condition') as "condition",
json_extract_path_text(properties, '$.conditionVersion') as "condition_version",
json_extract_path_text(properties, '$.createdOn') as "created_on",
json_extract_path_text(properties, '$.expandedProperties') as "expanded_properties",
scope,
roleAssignmentScheduleInstanceName
FROM azure.authorization.role_assignment_schedule_instances
WHERE scope = 'replace-me';