steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_ami_shared

An Amazon Machine Image is a special type of virtual appliance that is used to create a virtual machine within the Amazon Elastic Compute Cloud.

You must specify an Owner ID or Image ID in a where clause (where owner_id='), (where image_id=').

The aws_ec2_ami_shared table can list any image but you must specify owner_id or image_id. If you want to list all of the images in your account then you can use the aws_ec2_ami table.

Examples

Basic info

select
  name,
  image_id,
  state,
  image_location,
  creation_date,
  public,
  root_device_name
from
  aws_ec2_ami_shared
where
  owner_id = '137112412989';

List arm64 AMIs

select
  name,
  image_id,
  state,
  image_location,
  creation_date,
  public,
  root_device_name
from
  aws_ec2_ami_shared
where
  owner_id = '137112412989'
  and architecture = 'arm64';

List EC2 instances using AMIs owned by a specific AWS account

select
  i.title,
  i.instance_id,
  i.image_id,
  ami.name,
  ami.description,
  ami.platform_details
from
  aws_ec2_instance as i
  join aws_ec2_ami_shared as ami on i.image_id = ami.image_id
where
  ami.owner_id = '137112412989';

.inspect aws_ec2_ami_shared

AWS EC2 AMI - All public, private, and shared AMIs

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.
architecture	text	The architecture of the image.
block_device_mappings	jsonb	Any block device mapping entries.
creation_date	timestamp with time zone	The date and time when the image was created.
description	text	The description of the AMI that was provided during image creation.
ena_support	boolean	Specifies whether enhanced networking with ENA is enabled.
hypervisor	text	The hypervisor type of the image.
image_id	text	The ID of the AMI.
image_location	text	The location of the AMI.
image_owner_alias	text	The AWS account alias (for example, amazon, self) or the AWS account ID of the AMI owner.
image_type	text	The type of image.
imds_support	text	If v2.0, it indicates that IMDSv2 is specified in the AMI.
kernel_id	text	The kernel associated with the image, if any. Only applicable for machine images.
name	text	The name of the AMI that was provided during image creation.
owner_id	text	The AWS account ID of the image owner.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform	text	This value is set to windows for Windows AMIs; otherwise, it is blank.
platform_details	text	The platform details associated with the billing code of the AMI. For more information, see Obtaining Billing Information (https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ami-billing-info.html) in the Amazon Elastic Compute Cloud User Guide.
product_codes	jsonb	Any product codes associated with the AMI.
public	boolean	Indicates whether the image has public launch permissions. The value is true if this image has public launch permissions or false if it has only implicit and explicit launch permissions.
ramdisk_id	text	The RAM disk associated with the image, if any. Only applicable for machine images.
region	text	The AWS Region in which the resource is located.
root_device_name	text	The device name of the root device volume (for example, /dev/sda1).
root_device_type	text	The type of root device used by the AMI. The AMI can use an EBS volume or an instance store volume.
sriov_net_support	text	Specifies whether enhanced networking with the Intel 82599 Virtual Function interface is enabled.
state	text	The current state of the AMI. If the state is available, the image is successfully registered and can be used to launch an instance.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the AMI.
title	text	Title of the resource.
usage_operation	text	The operation of the Amazon EC2 instance and the billing code that is associated with the AMI. For the list of UsageOperation codes, see Platform Details and [Usage Operation Billing Codes](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ami-billing-info.html#billing-info) in the Amazon Elastic Compute Cloud User Guide.
virtualization_type	text	The type of virtualization of the AMI.

turbot/aws

Table: aws_ec2_ami_shared

Examples

Basic info

List arm64 AMIs

List EC2 instances using AMIs owned by a specific AWS account

.inspect aws_ec2_ami_shared

Steampipe

Resources

Community