steampipe plugin install awssteampipe plugin install aws

Table: aws_appstream_fleet

AWS AppStream Fleet is a group of streaming instances that deliver desktop applications to users. It is a service provided by Amazon Web Services (AWS) that allows you to stream desktop applications from the cloud to any device with an internet connection. A fleet consists of a collection of streaming instances that are provisioned and managed as a single entity. These instances run the applications and stream the user interface and input/output back and forth between the user's device and the cloud. AppStream Fleet helps simplify the management and delivery of applications, allowing users to access their applications securely from anywhere.

Examples

Basic info

select
  name,
  arn,
  instance_type,
  description,
  created_time,
  display_name,
  state,
  directory_name,
  enable_default_internet_access
from
  aws_appstream_fleet;

List fleets that have default internet access anabled

select
  name,
  arn,
  instance_type,
  description,
  created_time,
  display_name,
  state,
  enable_default_internet_access
from
  aws_appstream_fleet
where
  enable_default_internet_access;

List on-demand fleets

select
  name,
  created_time,
  fleet_type,
  instance_type,
  display_name,
  image_arn,
  image_name
from
  aws_appstream_fleet
where
  fleet_type = 'ON_DEMAND';

List fleets that are created in last 30 days

select
  name,
  created_time,
  display_name,
  enable_default_internet_access,
  max_concurrent_sessions,
  max_user_duration_in_seconds
from
  aws_appstream_fleet
where
  created_time >= now() - interval '30' day;

List fleets that are using private images

select
  f.name,
  f.created_time,
  f.display_name,
  f.image_arn,
  i.base_image_arn,
  i.image_builder_name,
  i.visibility
from
  aws_appstream_fleet as f,
  aws_appstream_image as i
where
  i.arn = f.image_arn
  and i.visibility = 'PRIVATE';

Get compute capacity status of each fleet

select
  name,
  arn,
  compute_capacity_status ->> 'Available' as available,
  compute_capacity_status ->> 'Desired' as desired,
  compute_capacity_status ->> 'InUse' as in_use,
  compute_capacity_status ->> 'Running' as running
from
  aws_appstream_fleet;

Get error details of failed images

select
  name,
  arn,
  e ->> 'ErrorCode' as error_code,
  e ->> 'ErrorMessage' as error_message
from
  aws_appstream_fleet,
  jsonb_array_elements(fleet_errors) as e;

Get VPC config details of each fleet

select
  name,
  arn,
  vpc_config -> 'SecurityGroupIds' as security_group_ids,
  vpc_config -> 'SubnetIds' as subnet_ids
from
  aws_appstream_fleet;

Count fleets by instance type

select
  name,
  instance_type,
  Count(instance_type) as number_of_fleets
from
  aws_appstream_fleet
group by
  instance_type,
  name;

List fleets that are in running state

select
  name,
  arn,
  state,
  created_time,
  description
from
  aws_appstream_fleet
where
  state = 'RUNNING';

.inspect aws_appstream_fleet

AWS AppStream Fleet

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.
arn	text	The Amazon Resource Name (ARN) for the fleet.
compute_capacity_status	jsonb	The capacity status for the fleet.
created_time	timestamp with time zone	The time the fleet was created.
description	text	The description to display.
directory_name	text	The fully qualified name of the directory (for example, corp.example.com).
disconnect_timeout_in_seconds	bigint	The amount of time that a streaming session remains active after users disconnect. If they try to reconnect to the streaming session after a disconnection or network interruption within this time interval, they are connected to their previous session. Otherwise, they are connected to a new session with a new streaming instance. Specify a value between 60 and 360000.
display_name	text	The fleet name to display.
enable_default_internet_access	boolean	Indicates whether default internet access is enabled for the fleet.
fleet_errors	jsonb	The fleet errors.
fleet_type	text	The fleet type. ALWAYS_ON Provides users with instant-on access to their apps. You are charged for all running instances in your fleet, even if no users are streaming apps. ON_DEMAND Provide users with access to applications after they connect, which takes one to two minutes. You are charged for instance streaming when users are connected and a small hourly fee for instances that are not streaming apps.
iam_role_arn	text	The ARN of the IAM role that is applied to the fleet.
idle_disconnect_timeout_in_seconds	bigint	The amount of time that users can be idle (inactive) before they are disconnected from their streaming session and the DisconnectTimeoutInSeconds time interval begins.
image_arn	text	The ARN for the public, private, or shared image.
image_name	text	The name of the image used to create the fleet.
instance_type	text	The instance type to use when launching fleet instances.
max_concurrent_sessions	bigint	The maximum number of concurrent sessions for the fleet.
max_user_duration_in_seconds	bigint	The maximum amount of time that a streaming session can remain active, in seconds. If users are still connected to a streaming instance five minutes before this limit is reached, they are prompted to save any open documents before being disconnected.
name	text	The name of the fleet.
organizational_unit_distinguished_name	text	The distinguished name of the organizational unit for computer accounts.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform	text	The platform of the fleet.
region	text	The AWS Region in which the resource is located.
session_script_s3_location	jsonb	The S3 location of the session scripts configuration zip file. This only applies to Elastic fleets.
state	text	The current state for the fleet.
stream_view	text	The AppStream 2.0 view that is displayed to your users when they stream from the fleet. When APP is specified, only the windows of applications opened by users display. When DESKTOP is specified, the standard desktop that is provided by the operating system displays. The default value is APP.
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.
usb_device_filter_strings	jsonb	The USB device filter strings associated with the fleet.
vpc_config	jsonb	The VPC configuration for the fleet.

turbot/aws