images

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

Overview

Name	images
Type	Resource
Id	azure.lab_services.images

Fields

vw_images

Name	Datatype	Description
description	text	field from the properties object
author	text	field from the properties object
available_regions	text	field from the properties object
display_name	text	field from the properties object
enabled_state	text	field from the properties object
icon_url	text	field from the properties object
imageName	text	field from the properties object
labPlanName	text	field from the properties object
offer	text	field from the properties object
os_state	text	field from the properties object
os_type	text	field from the properties object
plan	text	field from the properties object
provisioning_state	text	field from the properties object
publisher	text	field from the properties object
resourceGroupName	text	field from the properties object
shared_gallery_id	text	field from the properties object
sku	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
terms_status	text	field from the properties object
version	text	field from the properties object

images

Name	Datatype	Description
properties	object	Properties of an image resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	imageName, labPlanName, resourceGroupName, subscriptionId	Gets an image resource.
list_by_lab_plan	SELECT	labPlanName, resourceGroupName, subscriptionId	Gets all images from galleries attached to a lab plan.
create_or_update	INSERT	imageName, labPlanName, resourceGroupName, subscriptionId, data__properties	Updates an image resource via PUT. Creating new resources via PUT will not function.
update	UPDATE	imageName, labPlanName, resourceGroupName, subscriptionId	Updates an image resource.

SELECT examples

Gets all images from galleries attached to a lab plan.

vw_images

SELECT
description,
author,
available_regions,
display_name,
enabled_state,
icon_url,
imageName,
labPlanName,
offer,
os_state,
os_type,
plan,
provisioning_state,
publisher,
resourceGroupName,
shared_gallery_id,
sku,
subscriptionId,
system_data,
terms_status,
version
FROM azure.lab_services.vw_images
WHERE labPlanName = '{{ labPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

images

SELECT
properties,
systemData
FROM azure.lab_services.images
WHERE labPlanName = '{{ labPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.lab_services.images (
imageName,
labPlanName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ imageName }}',
'{{ labPlanName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: enabledState
          value: []
        - name: provisioningState
          value: []
        - name: displayName
          value: string
        - name: description
          value: string
        - name: iconUrl
          value: string
        - name: author
          value: string
        - name: osType
          value: []
        - name: plan
          value: string
        - name: offer
          value: string
        - name: publisher
          value: string
        - name: sku
          value: string
        - name: version
          value: string
        - name: sharedGalleryId
          value: []
        - name: availableRegions
          value:
            - string
        - name: osState
          value: []

UPDATE example

Updates a images resource.

/*+ update */
UPDATE azure.lab_services.images
SET 
properties = '{{ properties }}'
WHERE 
imageName = '{{ imageName }}'
AND labPlanName = '{{ labPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';