products

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

Overview

Name	products
Type	Resource
Id	azure_stack.azure_bridge_admin.products

Fields

vw_products

Name	Datatype	Description
id	text	URI of the resource.
name	text	Name of the resource.
description	text	field from the properties object
activationName	text	field from the properties object
billing_part_number	text	field from the properties object
compatibility	text	field from the properties object
display_name	text	field from the properties object
gallery_item_identity	text	field from the properties object
icon_uris	text	field from the properties object
legal_terms	text	field from the properties object
links	text	field from the properties object
location	text	Location of the resource
offer	text	field from the properties object
offer_version	text	field from the properties object
payload_length	text	field from the properties object
privacy_policy	text	field from the properties object
productName	text	field from the properties object
product_kind	text	field from the properties object
product_properties	text	field from the properties object
provisioning_state	text	field from the properties object
publisher_display_name	text	field from the properties object
publisher_identifier	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	List of key value pairs.
type	text	Type of resource.
vm_extension_type	text	field from the properties object

products

Name	Datatype	Description
id	string	URI of the resource.
name	string	Name of the resource.
location	string	Location of the resource
properties	object	Properties for a product.
tags	object	List of key value pairs.
type	string	Type of resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	activationName, productName, resourceGroupName, subscriptionId	Return product name.
list	SELECT	activationName, resourceGroupName, subscriptionId	Return product name.
download	EXEC	activationName, productName, resourceGroupName, subscriptionId	Downloads a product from azure marketplace.

SELECT examples

Return product name.

vw_products

SELECT
id,
name,
description,
activationName,
billing_part_number,
compatibility,
display_name,
gallery_item_identity,
icon_uris,
legal_terms,
links,
location,
offer,
offer_version,
payload_length,
privacy_policy,
productName,
product_kind,
product_properties,
provisioning_state,
publisher_display_name,
publisher_identifier,
resourceGroupName,
sku,
subscriptionId,
tags,
type,
vm_extension_type
FROM azure_stack.azure_bridge_admin.vw_products
WHERE activationName = '{{ activationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

products

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_stack.azure_bridge_admin.products
WHERE activationName = '{{ activationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';