Skip to main content

vw_products

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

Overview​

Namevw_products
TypeView
Idazure_stack.azure_stack.vw_products

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
type as type,
etag as etag,
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.publisherDisplayName') as "publisher_display_name",
JSON_EXTRACT(properties, '$.publisherIdentifier') as "publisher_identifier",
JSON_EXTRACT(properties, '$.offer') as "offer",
JSON_EXTRACT(properties, '$.offerVersion') as "offer_version",
JSON_EXTRACT(properties, '$.sku') as "sku",
JSON_EXTRACT(properties, '$.billingPartNumber') as "billing_part_number",
JSON_EXTRACT(properties, '$.vmExtensionType') as "vm_extension_type",
JSON_EXTRACT(properties, '$.galleryItemIdentity') as "gallery_item_identity",
JSON_EXTRACT(properties, '$.iconUris') as "icon_uris",
JSON_EXTRACT(properties, '$.links') as "links",
JSON_EXTRACT(properties, '$.legalTerms') as "legal_terms",
JSON_EXTRACT(properties, '$.privacyPolicy') as "privacy_policy",
JSON_EXTRACT(properties, '$.payloadLength') as "payload_length",
JSON_EXTRACT(properties, '$.productKind') as "product_kind",
JSON_EXTRACT(properties, '$.productProperties') as "product_properties",
JSON_EXTRACT(properties, '$.compatibility') as "compatibility",
subscriptionId,
resourceGroup,
registrationName,
productName
FROM azure_stack.azure_stack.products
WHERE subscriptionId = 'replace-me' AND resourceGroup = 'replace-me' AND registrationName = 'replace-me';