Skip to main content

patch_schedules

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

Overview

Namepatch_schedules
TypeResource
Idazure.redis.patch_schedules

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
locationstringThe geo-location where the resource lives.
scheduleEntriesarrayList of patch schedules for a Redis cache. Required.
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
getselectresource_group_name, name, default_name, subscription_idGets the patching schedule of a redis cache.
list_by_redis_resourceselectresource_group_name, cache_name, subscription_idGets all patch schedules in the specified redis cache (there is only one).
create_or_updateinsertresource_group_name, name, default_name, subscription_id, propertiesCreate or replace the patching schedule for Redis cache.
create_or_updatereplaceresource_group_name, name, default_name, subscription_id, propertiesCreate or replace the patching schedule for Redis cache.
deletedeleteresource_group_name, name, default_name, subscription_idDeletes the patching schedule of a redis cache.

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
cache_namestringThe name of the Redis cache. Required.
default_namestringThe name of the RedisPatchSchedule. "default" Required.
namestringThe name of the redis cache. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the patching schedule of a redis cache.

SELECT
id,
name,
location,
scheduleEntries,
systemData,
type
FROM azure.redis.patch_schedules
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND name = '{{ name }}' -- required
AND default_name = '{{ default_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or replace the patching schedule for Redis cache.

INSERT INTO azure.redis.patch_schedules (
properties,
resource_group_name,
name,
default_name,
subscription_id
)
SELECT
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ name }}',
'{{ default_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
type
;

REPLACE examples

Create or replace the patching schedule for Redis cache.

REPLACE azure.redis.patch_schedules
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND name = '{{ name }}' --required
AND default_name = '{{ default_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND properties = '{{ properties }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
type;

DELETE examples

Deletes the patching schedule of a redis cache.

DELETE FROM azure.redis.patch_schedules
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND name = '{{ name }}' --required
AND default_name = '{{ default_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;