Skip to main content

vw_subscriptions

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

Overview​

Namevw_subscriptions
TypeView
Idazure.billing.vw_subscriptions

Fields​

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

SQL Definition​

SELECT
tags as tags,
JSON_EXTRACT(properties, '$.autoRenew') as "auto_renew",
JSON_EXTRACT(properties, '$.beneficiaryTenantId') as "beneficiary_tenant_id",
JSON_EXTRACT(properties, '$.beneficiary') as "beneficiary",
JSON_EXTRACT(properties, '$.billingFrequency') as "billing_frequency",
JSON_EXTRACT(properties, '$.billingProfileId') as "billing_profile_id",
JSON_EXTRACT(properties, '$.billingPolicies') as "billing_policies",
JSON_EXTRACT(properties, '$.billingProfileDisplayName') as "billing_profile_display_name",
JSON_EXTRACT(properties, '$.billingProfileName') as "billing_profile_name",
JSON_EXTRACT(properties, '$.consumptionCostCenter') as "consumption_cost_center",
JSON_EXTRACT(properties, '$.customerId') as "customer_id",
JSON_EXTRACT(properties, '$.customerDisplayName') as "customer_display_name",
JSON_EXTRACT(properties, '$.customerName') as "customer_name",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.enrollmentAccountId') as "enrollment_account_id",
JSON_EXTRACT(properties, '$.enrollmentAccountDisplayName') as "enrollment_account_display_name",
JSON_EXTRACT(properties, '$.enrollmentAccountSubscriptionDetails') as "enrollment_account_subscription_details",
JSON_EXTRACT(properties, '$.invoiceSectionId') as "invoice_section_id",
JSON_EXTRACT(properties, '$.invoiceSectionDisplayName') as "invoice_section_display_name",
JSON_EXTRACT(properties, '$.invoiceSectionName') as "invoice_section_name",
JSON_EXTRACT(properties, '$.lastMonthCharges') as "last_month_charges",
JSON_EXTRACT(properties, '$.monthToDateCharges') as "month_to_date_charges",
JSON_EXTRACT(properties, '$.nextBillingCycleDetails') as "next_billing_cycle_details",
JSON_EXTRACT(properties, '$.offerId') as "offer_id",
JSON_EXTRACT(properties, '$.productCategory') as "product_category",
JSON_EXTRACT(properties, '$.productType') as "product_type",
JSON_EXTRACT(properties, '$.productTypeId') as "product_type_id",
JSON_EXTRACT(properties, '$.purchaseDate') as "purchase_date",
JSON_EXTRACT(properties, '$.quantity') as "quantity",
JSON_EXTRACT(properties, '$.reseller') as "reseller",
JSON_EXTRACT(properties, '$.renewalTermDetails') as "renewal_term_details",
JSON_EXTRACT(properties, '$.skuId') as "sku_id",
JSON_EXTRACT(properties, '$.skuDescription') as "sku_description",
JSON_EXTRACT(properties, '$.systemOverrides') as "system_overrides",
JSON_EXTRACT(properties, '$.resourceUri') as "resource_uri",
JSON_EXTRACT(properties, '$.termDuration') as "term_duration",
JSON_EXTRACT(properties, '$.termStartDate') as "term_start_date",
JSON_EXTRACT(properties, '$.termEndDate') as "term_end_date",
JSON_EXTRACT(properties, '$.provisioningTenantId') as "provisioning_tenant_id",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.operationStatus') as "operation_status",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.subscriptionId') as "subscription_id",
JSON_EXTRACT(properties, '$.suspensionReasons') as "suspension_reasons",
JSON_EXTRACT(properties, '$.suspensionReasonDetails') as "suspension_reason_details",
billingAccountName,
billingProfileName,
billingSubscriptionName
FROM azure.billing.subscriptions
WHERE billingAccountName = 'replace-me';