turbot/aws_insights

Query: ec2_ami_tags

Usage

powerpipe query aws_insights.query.ec2_ami_tags

Steampipe Tables

SQL

select
t ->> 'Key' as "Key",
t ->> 'Value' as "Value"
from
aws_ec2_ami a,
jsonb_array_elements(a.tags_src) as t
where
image_id = $1
order by
t ->> 'Key';

Dashboards

The query is used in the dashboards: