steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_reserved_instance

Amazon EC2 Reserved Instances (RI) provide a significant discount (up to 72%) compared to On-Demand pricing and provide a capacity reservation when used in a specific Availability Zone.

Examples

Basic Info

select
  reserved_instance_id,
  arn,
  instance_type,
  instance_state,
  currency_code,
  CAST(fixed_price AS varchar),
  offering_class,
  scope,
  CAST(usage_price AS varchar)
from
  aws_ec2_reserved_instance;

Count reserved instances by instance type

select
  instance_type,
  count(instance_count) as count
from
  aws_ec2_reserved_instance
group by
  instance_type;

List reserved instances provisioned with undesired(for example t2.large and m3.medium is desired) instance type(s)

select
  instance_type,
  count(*) as count
from
  aws_ec2_reserved_instance
where
  instance_type not in ('t2.large', 'm3.medium')
group by
  instance_type;

List standard offering class type reserved instances

select
  reserved_instance_id,
  instance_type,
  offering_class
from
  aws_ec2_reserved_instance
where
  offering_class = 'standard';

List active reserved instances

select
  reserved_instance_id,
  instance_type,
  instance_state
from
  aws_ec2_reserved_instance
where
  instance_state = 'active';

Control examples

.inspect aws_ec2_reserved_instance

AWS EC2 Reserved Instance

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) specifying the instance.
availability_zone	text	The Availability Zone in which the Reserved Instance can be used.
currency_code	text	The currency of the Reserved Instance. It's specified using ISO 4217 standard currency codes. At this time, the only supported currency is USD.
duration	bigint	The duration of the Reserved Instance, in seconds.
end_time	timestamp with time zone	The time when the Reserved Instance expires.
fixed_price	double precision	The purchase price of the Reserved Instance.
instance_count	bigint	The number of reservations purchased.
instance_state	text	The state of the Reserved Instance purchase.
instance_tenancy	text	The tenancy of the instance.
instance_type	text	The instance type on which the Reserved Instance can be used.
offering_class	text	The offering class of the Reserved Instance.
offering_type	text	The Reserved Instance offering type.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
product_description	text	The Reserved Instance product platform description.
region	text	The AWS Region in which the resource is located.
reserved_instance_id	text	The ID of the Reserved instance.
reserved_instances_modifications	jsonb	The Reserved Instance modification information.
scope	text	The scope of the Reserved Instance.
start_time	timestamp with time zone	The date and time the Reserved Instance started.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the reserved instance.
title	text	Title of the resource.
usage_price	double precision	The usage price of the Reserved Instance, per hour.

turbot/aws