turbot/azure_insights

Query: compute_disk_age_table

Usage

powerpipe query azure_insights.query.compute_disk_age_table

SQL

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

Dashboards

The query is used in the dashboards: