role_assignment_schedule_requests

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

Overview

Name	role_assignment_schedule_requests
Type	Resource
Id	azure.authorization.role_assignment_schedule_requests

Fields

vw_role_assignment_schedule_requests

Name	Datatype	Description
id	text	The role assignment schedule request ID.
name	text	The role assignment schedule request name.
approval_id	text	field from the properties object
condition	text	field from the properties object
condition_version	text	field from the properties object
created_on	text	field from the properties object
expanded_properties	text	field from the properties object
justification	text	field from the properties object
linked_role_eligibility_schedule_id	text	field from the properties object
principal_id	text	field from the properties object
principal_type	text	field from the properties object
request_type	text	field from the properties object
requestor_id	text	field from the properties object
roleAssignmentScheduleRequestName	text	field from the properties object
role_definition_id	text	field from the properties object
schedule_info	text	field from the properties object
scope	text	field from the properties object
status	text	field from the properties object
target_role_assignment_schedule_id	text	field from the properties object
target_role_assignment_schedule_instance_id	text	field from the properties object
ticket_info	text	field from the properties object
type	text	The role assignment schedule request type.

role_assignment_schedule_requests

Name	Datatype	Description
id	string	The role assignment schedule request ID.
name	string	The role assignment schedule request name.
properties	object	Role assignment schedule request properties with scope.
type	string	The role assignment schedule request type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	roleAssignmentScheduleRequestName, scope	Get the specified role assignment schedule request.
list_for_scope	SELECT	scope	Gets role assignment schedule requests for a scope.
create	INSERT	roleAssignmentScheduleRequestName, scope	Creates a role assignment schedule request.
cancel	EXEC	roleAssignmentScheduleRequestName, scope	Cancels a pending role assignment schedule request.
validate	EXEC	roleAssignmentScheduleRequestName, scope	Validates a new role assignment schedule request.

SELECT examples

Gets role assignment schedule requests for a scope.

vw_role_assignment_schedule_requests

SELECT
id,
name,
approval_id,
condition,
condition_version,
created_on,
expanded_properties,
justification,
linked_role_eligibility_schedule_id,
principal_id,
principal_type,
request_type,
requestor_id,
roleAssignmentScheduleRequestName,
role_definition_id,
schedule_info,
scope,
status,
target_role_assignment_schedule_id,
target_role_assignment_schedule_instance_id,
ticket_info,
type
FROM azure.authorization.vw_role_assignment_schedule_requests
WHERE scope = '{{ scope }}';

role_assignment_schedule_requests

SELECT
id,
name,
properties,
type
FROM azure.authorization.role_assignment_schedule_requests
WHERE scope = '{{ scope }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.authorization.role_assignment_schedule_requests (
roleAssignmentScheduleRequestName,
scope,
properties
)
SELECT 
'{{ roleAssignmentScheduleRequestName }}',
'{{ scope }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: scope
          value: string
        - name: roleDefinitionId
          value: string
        - name: principalId
          value: string
        - name: principalType
          value: string
        - name: requestType
          value: string
        - name: status
          value: string
        - name: approvalId
          value: string
        - name: targetRoleAssignmentScheduleId
          value: string
        - name: targetRoleAssignmentScheduleInstanceId
          value: string
        - name: scheduleInfo
          value:
            - name: startDateTime
              value: string
            - name: expiration
              value:
                - name: type
                  value: string
                - name: endDateTime
                  value: string
                - name: duration
                  value: string
        - name: linkedRoleEligibilityScheduleId
          value: string
        - name: justification
          value: string
        - name: ticketInfo
          value:
            - name: ticketNumber
              value: string
            - name: ticketSystem
              value: string
        - name: condition
          value: string
        - name: conditionVersion
          value: string
        - name: createdOn
          value: string
        - name: requestorId
          value: string
        - name: expandedProperties
          value:
            - name: scope
              value:
                - name: id
                  value: string
                - name: displayName
                  value: string
                - name: type
                  value: string
            - name: roleDefinition
              value:
                - name: id
                  value: string
                - name: displayName
                  value: string
                - name: type
                  value: string
            - name: principal
              value:
                - name: id
                  value: string
                - name: displayName
                  value: string
                - name: email
                  value: string
                - name: type
                  value: string