turbot/gcp_insights

Query: kubernetes_cluster_age_table

Usage

powerpipe query gcp_insights.query.kubernetes_cluster_age_table

SQL

select
c.name as "Name",
c.id::text as "ID",
now()::date - c.create_time::date as "Age in Days",
c.create_time as "Create Time",
c.status as "Status",
p.name as "Project",
p.project_id as "Project ID",
c.location as "Location",
c.self_link as "Self-Link"
from
gcp_kubernetes_cluster as c,
gcp_project as p
where
p.project_id = c.project
order by
c.create_time,
c.name;

Dashboards

The query is used in the dashboards: