Query: key_vault_overview

select
  name as "Name",
  vault_uri as "Vault URI",
  type as "Type",
  cloud_environment as "Cloud Environment",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  tenant_id as "Tenant ID",
  id as "ID"
from
  azure_key_vault
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);