scaling_plan_pooled_schedules

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

Overview

Name	scaling_plan_pooled_schedules
Type	Resource
Id	azure.desktop_virtualization.scaling_plan_pooled_schedules

Fields

vw_scaling_plan_pooled_schedules

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
days_of_week	text	field from the properties object
off_peak_load_balancing_algorithm	text	field from the properties object
off_peak_start_time	text	field from the properties object
peak_load_balancing_algorithm	text	field from the properties object
peak_start_time	text	field from the properties object
ramp_down_capacity_threshold_pct	text	field from the properties object
ramp_down_force_logoff_users	text	field from the properties object
ramp_down_load_balancing_algorithm	text	field from the properties object
ramp_down_minimum_hosts_pct	text	field from the properties object
ramp_down_notification_message	text	field from the properties object
ramp_down_start_time	text	field from the properties object
ramp_down_stop_hosts_when	text	field from the properties object
ramp_down_wait_time_minutes	text	field from the properties object
ramp_up_capacity_threshold_pct	text	field from the properties object
ramp_up_load_balancing_algorithm	text	field from the properties object
ramp_up_minimum_hosts_pct	text	field from the properties object
ramp_up_start_time	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
system_data	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

scaling_plan_pooled_schedules

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	A ScalingPlanPooledSchedule.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

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

SELECT examples

List ScalingPlanPooledSchedules.

vw_scaling_plan_pooled_schedules

SELECT
id,
name,
days_of_week,
off_peak_load_balancing_algorithm,
off_peak_start_time,
peak_load_balancing_algorithm,
peak_start_time,
ramp_down_capacity_threshold_pct,
ramp_down_force_logoff_users,
ramp_down_load_balancing_algorithm,
ramp_down_minimum_hosts_pct,
ramp_down_notification_message,
ramp_down_start_time,
ramp_down_stop_hosts_when,
ramp_down_wait_time_minutes,
ramp_up_capacity_threshold_pct,
ramp_up_load_balancing_algorithm,
ramp_up_minimum_hosts_pct,
ramp_up_start_time,
resourceGroupName,
scalingPlanName,
scalingPlanScheduleName,
subscriptionId,
system_data,
type
FROM azure.desktop_virtualization.vw_scaling_plan_pooled_schedules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND scalingPlanName = '{{ scalingPlanName }}'
AND subscriptionId = '{{ subscriptionId }}';

scaling_plan_pooled_schedules

SELECT
id,
name,
properties,
systemData,
type
FROM azure.desktop_virtualization.scaling_plan_pooled_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_pooled_schedules resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - 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
    - name: properties
      value:
        - name: daysOfWeek
          value:
            - string
        - name: rampUpStartTime
          value:
            - name: hour
              value: integer
            - name: minute
              value: integer
        - name: rampUpLoadBalancingAlgorithm
          value: string
        - name: rampUpMinimumHostsPct
          value: integer
        - name: rampUpCapacityThresholdPct
          value: integer
        - name: peakLoadBalancingAlgorithm
          value: string
        - name: rampDownLoadBalancingAlgorithm
          value: string
        - name: rampDownMinimumHostsPct
          value: integer
        - name: rampDownCapacityThresholdPct
          value: integer
        - name: rampDownForceLogoffUsers
          value: boolean
        - name: rampDownStopHostsWhen
          value: string
        - name: rampDownWaitTimeMinutes
          value: integer
        - name: rampDownNotificationMessage
          value: string
        - name: offPeakLoadBalancingAlgorithm
          value: string

UPDATE example

Updates a scaling_plan_pooled_schedules resource.

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

DELETE example

Deletes the specified scaling_plan_pooled_schedules resource.

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