scaling_plan_personal_schedules

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

Overview

Name	scaling_plan_personal_schedules
Type	Resource
Id	azure.desktop_virtualization.scaling_plan_personal_schedules

Fields

vw_scaling_plan_personal_schedules

Name	Datatype	Description
days_of_week	text	field from the properties object
off_peak_action_on_disconnect	text	field from the properties object
off_peak_action_on_logoff	text	field from the properties object
off_peak_minutes_to_wait_on_disconnect	text	field from the properties object
off_peak_minutes_to_wait_on_logoff	text	field from the properties object
off_peak_start_time	text	field from the properties object
off_peak_start_vm_on_connect	text	field from the properties object
peak_action_on_disconnect	text	field from the properties object
peak_action_on_logoff	text	field from the properties object
peak_minutes_to_wait_on_disconnect	text	field from the properties object
peak_minutes_to_wait_on_logoff	text	field from the properties object
peak_start_time	text	field from the properties object
peak_start_vm_on_connect	text	field from the properties object
ramp_down_action_on_disconnect	text	field from the properties object
ramp_down_action_on_logoff	text	field from the properties object
ramp_down_minutes_to_wait_on_disconnect	text	field from the properties object
ramp_down_minutes_to_wait_on_logoff	text	field from the properties object
ramp_down_start_time	text	field from the properties object
ramp_down_start_vm_on_connect	text	field from the properties object
ramp_up_action_on_disconnect	text	field from the properties object
ramp_up_action_on_logoff	text	field from the properties object
ramp_up_auto_start_hosts	text	field from the properties object
ramp_up_minutes_to_wait_on_disconnect	text	field from the properties object
ramp_up_minutes_to_wait_on_logoff	text	field from the properties object
ramp_up_start_time	text	field from the properties object
ramp_up_start_vm_on_connect	text	field from the properties object
resourceGroupName	text	field from the properties object
scalingPlanName	text	field from the properties object
scalingPlanScheduleName	text	field from the properties object
subscriptionId	text	field from the properties object

scaling_plan_personal_schedules

Name	Datatype	Description
properties	object	A ScalingPlanPersonalSchedule.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, scalingPlanName, scalingPlanScheduleName, subscriptionId	Get a ScalingPlanPersonalSchedule.
list	SELECT	resourceGroupName, scalingPlanName, subscriptionId	List ScalingPlanPersonalSchedules.
create	INSERT	resourceGroupName, scalingPlanName, scalingPlanScheduleName, subscriptionId, data__properties	Create or update a ScalingPlanPersonalSchedule.
delete	DELETE	resourceGroupName, scalingPlanName, scalingPlanScheduleName, subscriptionId	Remove a ScalingPlanPersonalSchedule.
update	UPDATE	resourceGroupName, scalingPlanName, scalingPlanScheduleName, subscriptionId	Update a ScalingPlanPersonalSchedule.

SELECT examples

List ScalingPlanPersonalSchedules.

vw_scaling_plan_personal_schedules

SELECT
days_of_week,
off_peak_action_on_disconnect,
off_peak_action_on_logoff,
off_peak_minutes_to_wait_on_disconnect,
off_peak_minutes_to_wait_on_logoff,
off_peak_start_time,
off_peak_start_vm_on_connect,
peak_action_on_disconnect,
peak_action_on_logoff,
peak_minutes_to_wait_on_disconnect,
peak_minutes_to_wait_on_logoff,
peak_start_time,
peak_start_vm_on_connect,
ramp_down_action_on_disconnect,
ramp_down_action_on_logoff,
ramp_down_minutes_to_wait_on_disconnect,
ramp_down_minutes_to_wait_on_logoff,
ramp_down_start_time,
ramp_down_start_vm_on_connect,
ramp_up_action_on_disconnect,
ramp_up_action_on_logoff,
ramp_up_auto_start_hosts,
ramp_up_minutes_to_wait_on_disconnect,
ramp_up_minutes_to_wait_on_logoff,
ramp_up_start_time,
ramp_up_start_vm_on_connect,
resourceGroupName,
scalingPlanName,
scalingPlanScheduleName,
subscriptionId
FROM azure.desktop_virtualization.vw_scaling_plan_personal_schedules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND scalingPlanName = '{{ scalingPlanName }}'
AND subscriptionId = '{{ subscriptionId }}';

scaling_plan_personal_schedules

SELECT
properties
FROM azure.desktop_virtualization.scaling_plan_personal_schedules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND scalingPlanName = '{{ scalingPlanName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.desktop_virtualization.scaling_plan_personal_schedules (
resourceGroupName,
scalingPlanName,
scalingPlanScheduleName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ scalingPlanName }}',
'{{ scalingPlanScheduleName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: daysOfWeek
          value:
            - string
        - name: rampUpStartTime
          value:
            - name: hour
              value: integer
            - name: minute
              value: integer
        - name: rampUpAutoStartHosts
          value: string
        - name: rampUpStartVMOnConnect
          value: string
        - name: rampUpActionOnDisconnect
          value: string
        - name: rampUpMinutesToWaitOnDisconnect
          value: integer
        - name: rampUpActionOnLogoff
          value: string
        - name: rampUpMinutesToWaitOnLogoff
          value: integer
        - name: peakStartVMOnConnect
          value: string
        - name: peakActionOnDisconnect
          value: string
        - name: peakMinutesToWaitOnDisconnect
          value: integer
        - name: peakActionOnLogoff
          value: string
        - name: peakMinutesToWaitOnLogoff
          value: integer
        - name: rampDownStartVMOnConnect
          value: string
        - name: rampDownActionOnDisconnect
          value: string
        - name: rampDownMinutesToWaitOnDisconnect
          value: integer
        - name: rampDownActionOnLogoff
          value: string
        - name: rampDownMinutesToWaitOnLogoff
          value: integer
        - name: offPeakStartVMOnConnect
          value: string
        - name: offPeakActionOnDisconnect
          value: string
        - name: offPeakMinutesToWaitOnDisconnect
          value: integer
        - name: offPeakActionOnLogoff
          value: string
        - name: offPeakMinutesToWaitOnLogoff
          value: integer

UPDATE example

Updates a scaling_plan_personal_schedules resource.

/*+ update */
UPDATE azure.desktop_virtualization.scaling_plan_personal_schedules
SET 
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND scalingPlanName = '{{ scalingPlanName }}'
AND scalingPlanScheduleName = '{{ scalingPlanScheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified scaling_plan_personal_schedules resource.

/*+ delete */
DELETE FROM azure.desktop_virtualization.scaling_plan_personal_schedules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND scalingPlanName = '{{ scalingPlanName }}'
AND scalingPlanScheduleName = '{{ scalingPlanScheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';