steampipe plugin install awssteampipe plugin install aws

Table: aws_appstream_image

Amazon AppStream 2.0 contains applications you can stream to your users and default system and application settings to enable your users to get started with those applications quickly. However, after you create an image, you can't change it. To add other applications, update existing applications, or change image settings, you must start and reconnect to the image builder that you used to create the image. If you deleted the image builder, launch a new image builder that is based on your image.

Examples

Basic info

select
  name,
  arn,
  base_image_arn,
  description,
  created_time,
  display_name,
  image_builder_name,
  tags
from
  aws_appstream_image;

List available images

select
  name,
  arn,
  display_name,
  platform,
  state
from
  aws_appstream_image
where
  state = 'AVAILABLE';

List Windows based images

select
  name,
  created_time,
  base_image_arn,
  display_name,
  image_builder_supported,
  image_builder_name
from
  aws_appstream_image
where
  platform = 'WINDOWS';

List images that support image builder

select
  name,
  created_time,
  base_image_arn,
  display_name,
  image_builder_supported,
  image_builder_name
from
  aws_appstream_image
where
  image_builder_supported;

List private images

select
  name,
  created_time,
  base_image_arn,
  display_name,
  image_builder_name,
  visibility
from
  aws_appstream_image
where
  visibility = 'PRIVATE';

Get application details of images

select
  name,
  arn,
  a ->> 'AppBlockArn' as app_block_arn,
  a ->> 'Arn' as app_arn,
  a ->> 'CreatedTime' as app_created_time,
  a ->> 'Description' as app_description,
  a ->> 'DisplayName' as app_display_name,
  a ->> 'Enabled' as app_enabled,
  a ->> 'IconS3Location' as app_icon_s3_location,
  a ->> 'IconURL' as app_icon_url,
  a ->> 'InstanceFamilies' as app_instance_families,
  a ->> 'LaunchParameters' as app_launch_parameters,
  a ->> 'LaunchPath' as app_launch_path,
  a ->> 'Name' as app_name,
  a ->> 'Platforms' as app_platforms,
  a ->> 'WorkingDirectory' as app_WorkingDirectory
from
  aws_appstream_image,
  jsonb_array_elements(applications) as a;

Get the permission model of the images

select
  name,
  arn,
  image_permissions ->> 'AllowFleet' as allow_fleet,
  image_permissions ->> 'AllowImageBuilder' as allow_image_builder
from
  aws_appstream_image;

Get error details of failed images

select
  name,
  arn,
  e ->> 'ErrorCode' as error_code,
  e ->> 'ErrorMessage' as error_message,
  e ->> 'ErrorTimestamp' as error_timestamp
from
  aws_appstream_image,
  jsonb_array_elements(image_errors) as e;

.inspect aws_appstream_image

AWS AppStream Image

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
applications	jsonb	The applications associated with the image.
appstream_agent_version	text	The version of the AppStream 2.0 agent to use for instances that are launched from this image.
arn	text	The Amazon Resource Name (ARN) of the image.
base_image_arn	text	The ARN of the image from which this image was created.
created_time	timestamp with time zone	The time the image was created.
description	text	The description to display.
display_name	text	The image name to display.
image_builder_name	text	The name of the image builder that was used to create the private image. If the image is shared, this value is null.
image_builder_supported	boolean	Indicates whether an image builder can be launched from this image.
image_errors	jsonb	Describes the errors that are returned when a new image can't be created.
image_permissions	jsonb	The permissions to provide to the destination AWS account for the specified image.
name	text	The name of the image.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform	text	The operating system platform of the image.
public_base_image_released_date	timestamp with time zone	The release date of the public base image. For private images, this date is the release date of the base image from which the image was created.
region	text	The AWS Region in which the resource is located.
state	text	The image starts in the PENDING state. If image creation succeeds, the state is AVAILABLE. If image creation fails, the state is FAILED.
state_change_reason	jsonb	The reason why the last state change occurred.
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.
visibility	text	Indicates whether the image is public or private.

turbot/aws