downloaded_products

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

Overview

Name	downloaded_products
Type	Resource
Id	azure_stack.azure_bridge_admin.downloaded_products

Fields

vw_downloaded_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
gallery_package_blob_sas_uri	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_details_properties	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

downloaded_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 aggregate usage.
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	Get a downloaded product.
list	SELECT	activationName, resourceGroupName, subscriptionId	Get a list of downloaded products.
create	INSERT	activationName, productName, resourceGroupName, subscriptionId	Creates a downloaded product.
delete	DELETE	activationName, productName, resourceGroupName, subscriptionId	Delete a downloaded product.

SELECT examples

Get a list of downloaded products.

vw_downloaded_products

SELECT
id,
name,
description,
activationName,
billing_part_number,
compatibility,
display_name,
gallery_item_identity,
gallery_package_blob_sas_uri,
icon_uris,
legal_terms,
links,
location,
offer,
offer_version,
payload_length,
privacy_policy,
productName,
product_details_properties,
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_downloaded_products
WHERE activationName = '{{ activationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

downloaded_products

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

INSERT example

Use the following StackQL query and manifest file to create a new downloaded_products resource.

All Properties

/*+ create */
INSERT INTO azure_stack.azure_bridge_admin.downloaded_products (
activationName,
productName,
resourceGroupName,
subscriptionId,
properties,
id,
name,
type
)
SELECT 
'{{ activationName }}',
'{{ productName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ id }}',
'{{ name }}',
'{{ type }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: vmExtensionType
          value: string
        - name: links
          value: []
        - name: legalTerms
          value: string
        - name: privacyPolicy
          value: string
        - name: provisioningState
          value: []
        - name: galleryPackageBlobSasUri
          value: string
        - name: productDetailsProperties
          value:
            - name: computeRole
              value: []
            - name: isSystemExtension
              value: boolean
            - name: sourceBlob
              value:
                - name: uri
                  value: string
            - name: supportMultipleExtensions
              value: boolean
            - name: version
              value: string
            - name: vmOsType
              value: []
            - name: vmScaleSetEnabled
              value: boolean
            - name: osDiskImage
              value:
                - name: sourceBlobSasUri
                  value: string
            - name: dataDiskImages
              value:
                - - name: lun
                    value: integer
                  - name: sourceBlobSasUri
                    value: string
        - name: displayName
          value: string
        - name: description
          value: string
        - name: publisherDisplayName
          value: string
        - name: publisherIdentifier
          value: string
        - name: offer
          value: string
        - name: offerVersion
          value: string
        - name: sku
          value: string
        - name: billingPartNumber
          value: string
        - name: galleryItemIdentity
          value: string
        - name: iconUris
          value:
            - name: hero
              value: string
            - name: large
              value: string
            - name: wide
              value: string
            - name: medium
              value: string
            - name: small
              value: string
        - name: payloadLength
          value: integer
        - name: productKind
          value: string
        - name: productProperties
          value:
            - name: version
              value: string
        - name: compatibility
          value:
            - name: isCompatible
              value: boolean
            - name: message
              value: string
            - name: description
              value: string
            - name: issues
              value:
                - []
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified downloaded_products resource.

/*+ delete */
DELETE FROM azure_stack.azure_bridge_admin.downloaded_products
WHERE activationName = '{{ activationName }}'
AND productName = '{{ productName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';