Skip to main content

apply_updates

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

Overview

Nameapply_updates
TypeResource
Idazure.maintenance.apply_updates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectProperties of the apply update
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, providerName, resourceType, resourceName, applyUpdateNameTrack maintenance updates to resource
listselectsubscriptionId
create_or_updateinsertsubscriptionId, resourceGroupName, providerName, resourceType, resourceNameApply maintenance updates to resource

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.

NameDatatypeDescription
applyUpdateNamestringapplyUpdate Id
providerNamestringResource provider name
resourceGroupNamestringResource group name
resourceNamestringResource identifier
resourceTypestringResource type
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Track maintenance updates to resource

SELECT
id,
name,
properties,
systemData,
type
FROM azure.maintenance.apply_updates
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND providerName = '{{ providerName }}' -- required
AND resourceType = '{{ resourceType }}' -- required
AND resourceName = '{{ resourceName }}' -- required
AND applyUpdateName = '{{ applyUpdateName }}' -- required
;

INSERT examples

Apply maintenance updates to resource

INSERT INTO azure.maintenance.apply_updates (
subscriptionId,
resourceGroupName,
providerName,
resourceType,
resourceName
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ providerName }}',
'{{ resourceType }}',
'{{ resourceName }}'
RETURNING
id,
name,
properties,
systemData,
type
;