turbot/azure_insights

Query: key_vault_key_input

Usage

powerpipe query azure_insights.query.key_vault_key_input

SQL

select
v.title as label,
lower(k.id) as value,
json_build_object(
'Key Name',
k.name,
'Vault Name',
v.vault_name,
'Subscription',
s.display_name,
'Resource_group',
v.resource_group,
'region',
v.region
) as tags
from
azure_key_vault_key as k
left join azure_key_vault_key_version as v on k.key_uri = v.key_uri,
azure_subscription as s
where
v.subscription_id = s.subscription_id
order by
v.title;

Dashboards

The query is used in the dashboards: