turbot/aws_insights

Query: eks_cluster_age_table

Usage

powerpipe query aws_insights.query.eks_cluster_age_table

SQL

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

Dashboards

The query is used in the dashboards: