turbot/aws_insights

Query: codecommit_repository_age_table

Usage

powerpipe query aws_insights.query.codecommit_repository_age_table

SQL

select
r.repository_id as "Repository ID",
r.repository_name as "Repository Name",
now()::date - r.creation_date::date as "Age in Days",
r.creation_date as "Creation Time",
a.title as "Account",
r.account_id as "Account ID",
r.region as "Region",
r.arn as "ARN"
from
aws_codecommit_repository as r,
aws_account as a
where
r.account_id = a.account_id
order by
r.creation_date,
r.repository_id;

Dashboards

The query is used in the dashboards: