turbot/steampipe-mod-azure-insights

Dashboard: Azure Compute Snapshot Detail

This dashboard answers the following questions for each snapshot:

  • How is the snapshot configured?
  • What relationships does the snapshot have with other resources?
  • What tags are applied?
  • What is the source of the snapshot?
  • Which disks, snapshots, disk encryption sets are managed by it?
This dashboard contains 4 cards, 1 graph, 1 input and 4 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-azure-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Azure Compute Snapshot Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run azure_insights.dashboard.compute_snapshot_detail --share

Queries

This dashboard uses the the following queries:
select
e.name as "Name",
e.encryption_type as "Encryption Type",
v.name as "Key Vault Name",
lower(v.id) as "Key Vault ID",
lower(k.key_id) as "Key ID",
k.name as "Key Name",
e.id as "ID"
from
azure_compute_disk_encryption_set as e
left join azure_compute_snapshot as s on lower(s.disk_encryption_set_id) = lower(e.id)
left join azure_key_vault as v on lower(v.id) = lower(e.active_key_source_vault_id)
left join azure_key_vault_key_version as k on lower(k.key_uri_with_version) = lower(e.active_key_url)
where
lower(s.id) = $1
and s.subscription_id = split_part($1, '/', 3);

Tags