Skip to main content

managed_hsms

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

Overview

Namemanaged_hsms
TypeResource
Idazure.key_vault.managed_hsms

Fields

The following fields are returned by SELECT queries:

Retrieved managed HSM Pool

NameDatatypeDescription
idstringThe Azure Resource Manager resource ID for the managed HSM Pool.
namestringThe name of the managed HSM Pool.
identityobjectManaged service identity (system assigned and/or user assigned identities)
locationstringThe supported Azure location where the managed HSM Pool should be created.
propertiesobjectProperties of the managed HSM
skuobjectSKU details
systemDataobjectMetadata pertaining to creation and last modification of the key vault resource.
tagsobjectResource tags
typestringThe resource type of the managed HSM Pool.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, name, subscriptionIdGets the specified managed HSM Pool.
list_by_resource_groupselectresourceGroupName, subscriptionId$topThe List operation gets information about the managed HSM Pools associated with the subscription and within the specified resource group.
list_by_subscriptionselectsubscriptionId$topThe List operation gets information about the managed HSM Pools associated with the subscription.
create_or_updateinsertresourceGroupName, name, subscriptionIdCreate or update a managed HSM Pool in the specified subscription.
updateupdateresourceGroupName, name, subscriptionIdUpdate a managed HSM Pool in the specified subscription.
deletedeleteresourceGroupName, name, subscriptionIdDeletes the specified managed HSM Pool.
purge_deletedexecname, location, subscriptionIdPermanently deletes the specified managed HSM.
check_mhsm_name_availabilityexecsubscriptionId, nameChecks that the managed hsm name is valid and is not already in use.

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
locationstringThe location of the soft-deleted managed HSM.
namestringThe name of the soft-deleted managed HSM.
resourceGroupNamestringName of the resource group that contains the managed HSM pool.
subscriptionIdstringSubscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
$topinteger (int32)Maximum number of results to return.

SELECT examples

Gets the specified managed HSM Pool.

SELECT
id,
name,
identity,
location,
properties,
sku,
systemData,
tags,
type
FROM azure.key_vault.managed_hsms
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Create or update a managed HSM Pool in the specified subscription.

INSERT INTO azure.key_vault.managed_hsms (
data__properties,
data__location,
data__sku,
data__tags,
data__identity,
resourceGroupName,
name,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ location }}',
'{{ sku }}',
'{{ tags }}',
'{{ identity }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
identity,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

Update a managed HSM Pool in the specified subscription.

UPDATE azure.key_vault.managed_hsms
SET
data__properties = '{{ properties }}',
data__location = '{{ location }}',
data__sku = '{{ sku }}',
data__tags = '{{ tags }}',
data__identity = '{{ identity }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
identity,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

Deletes the specified managed HSM Pool.

DELETE FROM azure.key_vault.managed_hsms
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;

Lifecycle Methods

Permanently deletes the specified managed HSM.

EXEC azure.key_vault.managed_hsms.purge_deleted 
@name='{{ name }}' --required,
@location='{{ location }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
;