turbot/azure_insights

Query: key_vault_key_by_key_expiration_status

Usage

powerpipe query azure_insights.query.key_vault_key_by_key_expiration_status

Steampipe Tables

SQL

select
status,
count(*)
from
(
select
expires_at,
case
when expires_at is not null then 'enabled'
else 'disabled'
end status
from
azure_key_vault_key
) as kv
group by
status
order by
status;

Dashboards

The query is used in the dashboards: