role_eligibility_schedule_requests

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

Overview

Name	role_eligibility_schedule_requests
Type	Resource
Id	azure.authorization.role_eligibility_schedule_requests

Fields

vw_role_eligibility_schedule_requests

Name	Datatype	Description
id	text	The role eligibility schedule request ID.
name	text	The role eligibility 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
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
roleEligibilityScheduleRequestName	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_eligibility_schedule_id	text	field from the properties object
target_role_eligibility_schedule_instance_id	text	field from the properties object
ticket_info	text	field from the properties object
type	text	The role eligibility schedule request type.

role_eligibility_schedule_requests

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

Methods

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

SELECT examples

Gets role eligibility schedule requests for a scope.

vw_role_eligibility_schedule_requests

SELECT
id,
name,
approval_id,
condition,
condition_version,
created_on,
expanded_properties,
justification,
principal_id,
principal_type,
request_type,
requestor_id,
roleEligibilityScheduleRequestName,
role_definition_id,
schedule_info,
scope,
status,
target_role_eligibility_schedule_id,
target_role_eligibility_schedule_instance_id,
ticket_info,
type
FROM azure.authorization.vw_role_eligibility_schedule_requests
WHERE scope = '{{ scope }}';

role_eligibility_schedule_requests

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.authorization.role_eligibility_schedule_requests (
roleEligibilityScheduleRequestName,
scope,
properties
)
SELECT 
'{{ roleEligibilityScheduleRequestName }}',
'{{ 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: scheduleInfo
          value:
            - name: startDateTime
              value: string
            - name: expiration
              value:
                - name: type
                  value: string
                - name: endDateTime
                  value: string
                - name: duration
                  value: string
        - name: targetRoleEligibilityScheduleId
          value: string
        - name: targetRoleEligibilityScheduleInstanceId
          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