Skip to main content

member_cap_overrides

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

Overview

Namemember_cap_overrides
TypeResource
Idazure.compute_limit.member_cap_overrides

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.
capintegerThe cap value in count units for this member subscription. Required.
provisioningStatestringThe provisioning state of the resource. Known values are: "Succeeded", "Failed", and "Canceled". (Succeeded, Failed, Canceled)
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
getselectlocation, vm_family_name, member_subscription_id, subscription_idGets the cap override configured for a single member subscription.
list_by_parentselectlocation, vm_family_name, subscription_idLists all per-member cap overrides configured under a SharedLimitCap.
create_or_updateinsertlocation, vm_family_name, member_subscription_id, subscription_idCreates or replaces the cap override for a single member subscription.
create_or_updatereplacelocation, vm_family_name, member_subscription_id, subscription_idCreates or replaces the cap override for a single member subscription.
deletedeletelocation, vm_family_name, member_subscription_id, subscription_idRemoves the per-member cap override for a member subscription.

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 name of the Azure region. Required.
member_subscription_idstringThe name of the MemberCapOverride. Required.
subscription_idstring
vm_family_namestringThe name of the SharedLimitCap. Required.

SELECT examples

Gets the cap override configured for a single member subscription.

SELECT
id,
name,
cap,
provisioningState,
systemData,
type
FROM azure.compute_limit.member_cap_overrides
WHERE location = '{{ location }}' -- required
AND vm_family_name = '{{ vm_family_name }}' -- required
AND member_subscription_id = '{{ member_subscription_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or replaces the cap override for a single member subscription.

INSERT INTO azure.compute_limit.member_cap_overrides (
properties,
location,
vm_family_name,
member_subscription_id,
subscription_id
)
SELECT
'{{ properties }}',
'{{ location }}',
'{{ vm_family_name }}',
'{{ member_subscription_id }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Creates or replaces the cap override for a single member subscription.

REPLACE azure.compute_limit.member_cap_overrides
SET
properties = '{{ properties }}'
WHERE
location = '{{ location }}' --required
AND vm_family_name = '{{ vm_family_name }}' --required
AND member_subscription_id = '{{ member_subscription_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Removes the per-member cap override for a member subscription.

DELETE FROM azure.compute_limit.member_cap_overrides
WHERE location = '{{ location }}' --required
AND vm_family_name = '{{ vm_family_name }}' --required
AND member_subscription_id = '{{ member_subscription_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;