turbot/azure_insights

Query: storage_account_age_table

Usage

powerpipe query azure_insights.query.storage_account_age_table

SQL

select
a.name as "Name",
now()::date - a.creation_time::date as "Age in Days",
a.creation_time as "Create Time",
a.kind as "Kind",
sub.title as "Subscription",
a.subscription_id as "Subscription ID",
a.resource_group as "Resource Group",
a.region as "Region",
lower(a.id) as "ID"
from
azure_storage_account as a,
azure_subscription as sub
where
a.subscription_id = sub.subscription_id
order by
a.creation_time,
a.name;

Dashboards

The query is used in the dashboards: