turbot/azure_insights

Query: compute_snapshot_age_table

Usage

powerpipe query azure_insights.query.compute_snapshot_age_table

SQL

select
s.name as "Name",
s.unique_id as "Unique ID",
now()::date - s.time_created::date as "Age in Days",
s.time_created as "Time Created",
sub.title as "Subscription",
s.subscription_id as "Subscription ID",
s.resource_group as "Resource Group",
s.region as "Region",
lower(s.id) as "ID"
from
azure_compute_snapshot as s,
azure_subscription as sub
where
s.subscription_id = sub.subscription_id
order by
s.time_created,
s.name;

Dashboards

The query is used in the dashboards: