Steampipe AWS One-Liners

Reading Time: < 1 minute

Here are some useful Steampipe queries for AWS

Need to know how to install Steampipe – see my blog post here.

Want Instances Do I Have Running in AWS?

select
  region,
  instance_id,
  instance_state,
  instance_type,
  title
from 
  aws_ec2_instance;

Find CIDRs Within CIDRs

select
  title as subnet,
  cidr_block
from
  aws_vpc_subnet
where
  cidr_block <<= '<CIDR>';

List KMS Keys that are not automatically rotated

select
  id,
  key_rotation_enabled
from
  aws_kms_key
where
  not key_rotation_enabled;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *