turbot/aws_insights

Query: ec2_ami_instances

Usage

powerpipe query aws_insights.query.ec2_ami_instances

Steampipe Tables

SQL

select
instance_id as "ID",
tags ->> 'Name' as "Name",
instance_state as "Instance State",
'/aws_insights.dashboard.ec2_instance_detail?input.instance_arn=' || arn as link
from
aws_ec2_instance
where
image_id = $1;

Dashboards

The query is used in the dashboards: