autoscale_settings
Creates, updates, deletes, gets or lists a autoscale_settings resource.
Overview
| Name | autoscale_settings |
| Type | Resource |
| Id | azure.monitor.autoscale_settings |
Fields
- vw_autoscale_settings
- autoscale_settings
| Name | Datatype | Description |
|---|---|---|
id | text | Azure resource Id |
name | text | Azure resource name |
autoscaleSettingName | text | field from the properties object |
enabled | text | field from the properties object |
location | text | Resource location |
notifications | text | field from the properties object |
predictive_autoscale_policy | text | field from the properties object |
profiles | 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 | Gets or sets a list of key value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). A maximum of 15 tags can be provided for a resource. Each tag must have a key no greater in length than 128 characters and a value no greater in length than 256 characters. |
target_resource_location | text | field from the properties object |
target_resource_uri | text | field from the properties object |
type | text | Azure resource type |
| Name | Datatype | Description |
|---|---|---|
id | string | Azure resource Id |
name | string | Azure resource name |
location | string | Resource location |
properties | object | A setting that contains all of the configuration for the automatic scaling of a resource. |
systemData | object | Metadata pertaining to creation and last modification of the resource. |
tags | object | Gets or sets a list of key value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). A maximum of 15 tags can be provided for a resource. Each tag must have a key no greater in length than 128 characters and a value no greater in length than 256 characters. |
type | string | Azure resource type |
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | autoscaleSettingName, resourceGroupName, subscriptionId | Gets an autoscale setting |
list_by_resource_group | SELECT | resourceGroupName, subscriptionId | Lists the autoscale settings for a resource group |
list_by_subscription | SELECT | subscriptionId | Lists the autoscale settings for a subscription |
create_or_update | INSERT | autoscaleSettingName, resourceGroupName, subscriptionId, data__properties | Creates or updates an autoscale setting. |
delete | DELETE | autoscaleSettingName, resourceGroupName, subscriptionId | Deletes and autoscale setting |
update | UPDATE | autoscaleSettingName, resourceGroupName, subscriptionId | Updates an existing AutoscaleSettingsResource. To update other fields use the CreateOrUpdate method. |
SELECT examples
Lists the autoscale settings for a subscription
- vw_autoscale_settings
- autoscale_settings
SELECT
id,
name,
autoscaleSettingName,
enabled,
location,
notifications,
predictive_autoscale_policy,
profiles,
resourceGroupName,
subscriptionId,
system_data,
tags,
target_resource_location,
target_resource_uri,
type
FROM azure.monitor.vw_autoscale_settings
WHERE subscriptionId = '{{ subscriptionId }}';
SELECT
id,
name,
location,
properties,
systemData,
tags,
type
FROM azure.monitor.autoscale_settings
WHERE subscriptionId = '{{ subscriptionId }}';
INSERT example
Use the following StackQL query and manifest file to create a new autoscale_settings resource.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.monitor.autoscale_settings (
autoscaleSettingName,
resourceGroupName,
subscriptionId,
data__properties,
location,
tags,
properties
)
SELECT
'{{ autoscaleSettingName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;
- name: your_resource_model_name
props:
- 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
- name: properties
value:
- name: profiles
value:
- - name: name
value: string
- name: capacity
value:
- name: minimum
value: string
- name: maximum
value: string
- name: default
value: string
- name: rules
value:
- - name: metricTrigger
value:
- name: metricName
value: string
- name: metricNamespace
value: string
- name: metricResourceUri
value: string
- name: metricResourceLocation
value: string
- name: timeGrain
value: string
- name: statistic
value: string
- name: timeWindow
value: string
- name: timeAggregation
value: string
- name: operator
value: string
- name: threshold
value: number
- name: dimensions
value:
- - name: DimensionName
value: string
- name: Operator
value: string
- name: Values
value:
- string
- name: dividePerInstance
value: boolean
- name: scaleAction
value:
- name: direction
value: string
- name: type
value: string
- name: value
value: string
- name: cooldown
value: string
- name: fixedDate
value:
- name: timeZone
value: string
- name: start
value: string
- name: end
value: string
- name: recurrence
value:
- name: frequency
value: string
- name: schedule
value:
- name: timeZone
value: string
- name: days
value:
- string
- name: hours
value:
- integer
- name: minutes
value:
- integer
- name: notifications
value:
- - name: operation
value: string
- name: email
value:
- name: sendToSubscriptionAdministrator
value: boolean
- name: sendToSubscriptionCoAdministrators
value: boolean
- name: customEmails
value:
- string
- name: webhooks
value:
- - name: serviceUri
value: string
- name: properties
value: object
- name: enabled
value: boolean
- name: predictiveAutoscalePolicy
value:
- name: scaleMode
value: string
- name: scaleLookAheadTime
value: string
- name: name
value: string
- name: targetResourceUri
value: string
- name: targetResourceLocation
value: string
UPDATE example
Updates a autoscale_settings resource.
/*+ update */
UPDATE azure.monitor.autoscale_settings
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
autoscaleSettingName = '{{ autoscaleSettingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';
DELETE example
Deletes the specified autoscale_settings resource.
/*+ delete */
DELETE FROM azure.monitor.autoscale_settings
WHERE autoscaleSettingName = '{{ autoscaleSettingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';