vw_group_quota_subscription_allocations

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

Overview

Name	vw_group_quota_subscription_allocations
Type	View
Id	azure.quota.vw_group_quota_subscription_allocations

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.region') as "region",
JSON_EXTRACT(properties, '$.limit') as "limit",
JSON_EXTRACT(properties, '$.shareableQuota') as "shareable_quota",
JSON_EXTRACT(properties, '$.name') as "name",
managementGroupId,
subscriptionId,
groupQuotaName,
resourceName,
$filter
FROM azure.quota.group_quota_subscription_allocations
WHERE managementGroupId = 'replace-me' AND subscriptionId = 'replace-me' AND groupQuotaName = 'replace-me' AND $filter = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.region') as "region",
json_extract_path_text(properties, '$.limit') as "limit",
json_extract_path_text(properties, '$.shareableQuota') as "shareable_quota",
json_extract_path_text(properties, '$.name') as "name",
managementGroupId,
subscriptionId,
groupQuotaName,
resourceName,
$filter
FROM azure.quota.group_quota_subscription_allocations
WHERE managementGroupId = 'replace-me' AND subscriptionId = 'replace-me' AND groupQuotaName = 'replace-me' AND $filter = 'replace-me';