turbot/aws_insights

Query: ecr_repository_age_table

Usage

powerpipe query aws_insights.query.ecr_repository_age_table

SQL

select
e.repository_name as "Name",
now() :: date - e.created_at :: date as "Age in Days",
e.created_at as "Created Time",
a.title as "Account",
e.account_id as "Account ID",
e.region as "Region",
e.arn as "ARN"
from
aws_ecr_repository as e,
aws_account as a
where
e.account_id = a.account_id
order by
e.created_at,
e.repository_name;

Dashboards

The query is used in the dashboards: