apply_updates

Creates, updates, deletes, gets or lists an apply_updates resource.

Overview

Name	apply_updates
Type	Resource
Id	azure.maintenance.apply_updates

Fields

The following fields are returned by SELECT queries:

get_parent

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
lastUpdateTime	string (date-time)	Last Update time.
resourceId	string	The resourceId.
status	string	The status. Known values are: "Pending", "InProgress", "Completed", "RetryNow", "RetryLater", "NoUpdatesPending", "Cancel", and "Cancelled". (Pending, InProgress, Completed, RetryNow, RetryLater, NoUpdatesPending, Cancel, Cancelled)
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
lastUpdateTime	string (date-time)	Last Update time.
resourceId	string	The resourceId.
status	string	The status. Known values are: "Pending", "InProgress", "Completed", "RetryNow", "RetryLater", "NoUpdatesPending", "Cancel", and "Cancelled". (Pending, InProgress, Completed, RetryNow, RetryLater, NoUpdatesPending, Cancel, Cancelled)
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
lastUpdateTime	string (date-time)	Last Update time.
resourceId	string	The resourceId.
status	string	The status. Known values are: "Pending", "InProgress", "Completed", "RetryNow", "RetryLater", "NoUpdatesPending", "Cancel", and "Cancelled". (Pending, InProgress, Completed, RetryNow, RetryLater, NoUpdatesPending, Cancel, Cancelled)
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_parent	select	resource_group_name, provider_name, resource_parent_type, resource_parent_name, resource_type, resource_name, apply_update_name, subscription_id		Track maintenance updates to resource with parent.
get	select	resource_group_name, provider_name, resource_type, resource_name, apply_update_name, subscription_id		Track maintenance updates to resource.
list	select	subscription_id		Get Configuration records within a subscription.
create_or_update	insert	resource_group_name, provider_name, resource_type, resource_name, subscription_id		Apply Updates to resource. Apply maintenance updates to resource.
create_or_update	replace	resource_group_name, provider_name, resource_type, resource_name, subscription_id		Apply Updates to resource. Apply maintenance updates to resource.
create_or_update_or_cancel	exec	resource_group_name, provider_name, resource_type, resource_name, apply_update_name, subscription_id		Apply maintenance updates to resource.
create_or_update_parent	exec	resource_group_name, provider_name, resource_parent_type, resource_parent_name, resource_type, resource_name, subscription_id		Apply Updates to resource with parent. Apply maintenance updates to resource with parent.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
apply_update_name	string	The name of the ApplyUpdate. Required.
provider_name	string	Resource provider name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
resource_name	string	Resource identifier. Required.
resource_parent_name	string	Resource parent identifier. Required.
resource_parent_type	string	Resource parent type. Required.
resource_type	string	Resource type. Required.
subscription_id	string

SELECT examples

get_parent

Track maintenance updates to resource with parent.

SELECT
id,
name,
lastUpdateTime,
resourceId,
status,
systemData,
type
FROM azure.maintenance.apply_updates
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND provider_name = '{{ provider_name }}' -- required
AND resource_parent_type = '{{ resource_parent_type }}' -- required
AND resource_parent_name = '{{ resource_parent_name }}' -- required
AND resource_type = '{{ resource_type }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND apply_update_name = '{{ apply_update_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

get

Track maintenance updates to resource.

SELECT
id,
name,
lastUpdateTime,
resourceId,
status,
systemData,
type
FROM azure.maintenance.apply_updates
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND provider_name = '{{ provider_name }}' -- required
AND resource_type = '{{ resource_type }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND apply_update_name = '{{ apply_update_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list

Get Configuration records within a subscription.

SELECT
id,
name,
lastUpdateTime,
resourceId,
status,
systemData,
type
FROM azure.maintenance.apply_updates
WHERE subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Apply Updates to resource. Apply maintenance updates to resource.

INSERT INTO azure.maintenance.apply_updates (
resource_group_name,
provider_name,
resource_type,
resource_name,
subscription_id
)
SELECT 
'{{ resource_group_name }}',
'{{ provider_name }}',
'{{ resource_type }}',
'{{ resource_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: apply_updates
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the apply_updates resource.
  - name: provider_name
    value: "{{ provider_name }}"
    description: Required parameter for the apply_updates resource.
  - name: resource_type
    value: "{{ resource_type }}"
    description: Required parameter for the apply_updates resource.
  - name: resource_name
    value: "{{ resource_name }}"
    description: Required parameter for the apply_updates resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the apply_updates resource.

REPLACE examples

create_or_update

Apply Updates to resource. Apply maintenance updates to resource.

REPLACE azure.maintenance.apply_updates
SET 
-- No updatable properties
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND provider_name = '{{ provider_name }}' --required
AND resource_type = '{{ resource_type }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

Lifecycle Methods

create_or_update_or_cancel

Apply maintenance updates to resource.

EXEC azure.maintenance.apply_updates.create_or_update_or_cancel 
@resource_group_name='{{ resource_group_name }}' --required, 
@provider_name='{{ provider_name }}' --required, 
@resource_type='{{ resource_type }}' --required, 
@resource_name='{{ resource_name }}' --required, 
@apply_update_name='{{ apply_update_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"properties": "{{ properties }}"
}'
;

create_or_update_parent

Apply Updates to resource with parent. Apply maintenance updates to resource with parent.

EXEC azure.maintenance.apply_updates.create_or_update_parent 
@resource_group_name='{{ resource_group_name }}' --required, 
@provider_name='{{ provider_name }}' --required, 
@resource_parent_type='{{ resource_parent_type }}' --required, 
@resource_parent_name='{{ resource_parent_name }}' --required, 
@resource_type='{{ resource_type }}' --required, 
@resource_name='{{ resource_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;