jit_requests

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

Overview

Name	jit_requests
Type	Resource
Id	azure.managed_applications.jit_requests

Fields

vw_jit_requests

Name	Datatype	Description
id	text	Resource ID
name	text	Resource name
application_resource_id	text	field from the properties object
created_by	text	field from the properties object
jitRequestName	text	field from the properties object
jit_authorization_policies	text	field from the properties object
jit_request_state	text	field from the properties object
jit_scheduling_policy	text	field from the properties object
location	text	Resource location
provisioning_state	text	field from the properties object
publisher_tenant_id	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags
type	text	Resource type
updated_by	text	field from the properties object

jit_requests

Name	Datatype	Description
id	string	Resource ID
name	string	Resource name
location	string	Resource location
properties	object	Information about JIT request properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jitRequestName, resourceGroupName, subscriptionId	Gets the JIT request.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all JIT requests within the resource group.
list_by_subscription	SELECT	subscriptionId	Lists all JIT requests within the subscription.
create_or_update	INSERT	jitRequestName, resourceGroupName, subscriptionId	Creates or updates the JIT request.
delete	DELETE	jitRequestName, resourceGroupName, subscriptionId	Deletes the JIT request.
update	UPDATE	jitRequestName, resourceGroupName, subscriptionId	Updates the JIT request.

SELECT examples

Lists all JIT requests within the subscription.

vw_jit_requests

SELECT
id,
name,
application_resource_id,
created_by,
jitRequestName,
jit_authorization_policies,
jit_request_state,
jit_scheduling_policy,
location,
provisioning_state,
publisher_tenant_id,
resourceGroupName,
subscriptionId,
system_data,
tags,
type,
updated_by
FROM azure.managed_applications.vw_jit_requests
WHERE subscriptionId = '{{ subscriptionId }}';

jit_requests

SELECT
id,
name,
location,
properties,
systemData,
tags,
type
FROM azure.managed_applications.jit_requests
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.managed_applications.jit_requests (
jitRequestName,
resourceGroupName,
subscriptionId,
properties,
location,
tags
)
SELECT 
'{{ jitRequestName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: applicationResourceId
          value: string
        - name: publisherTenantId
          value: string
        - name: jitAuthorizationPolicies
          value:
            - - name: principalId
                value: string
              - name: roleDefinitionId
                value: string
        - name: jitSchedulingPolicy
          value:
            - name: type
              value: []
            - name: duration
              value: string
            - name: startTime
              value: string
        - name: provisioningState
          value: []
        - name: jitRequestState
          value: []
        - name: createdBy
          value:
            - name: oid
              value: string
            - name: puid
              value: string
            - name: applicationId
              value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a jit_requests resource.

/*+ update */
UPDATE azure.managed_applications.jit_requests
SET 
tags = '{{ tags }}'
WHERE 
jitRequestName = '{{ jitRequestName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified jit_requests resource.

/*+ delete */
DELETE FROM azure.managed_applications.jit_requests
WHERE jitRequestName = '{{ jitRequestName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';