turbot/steampipe-mod-azure-insights

Dashboard: Azure Compute Virtual Machine Scale Set Detail

This dashboard answers the following questions for each virtual machine scale set:

  • How is the virtual machine scale set configured?
  • What relationships does the virtual machine scale set have with other resources?
  • What tags are applied?
  • Is logging enabled?
  • Which data disks, and network interfaces is it attached to?
  • How is encryption configured?
This dashboard contains 4 cards, 1 graph, 1 input and 7 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 Virtual Machine Scale Set Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
disk ->> 'caching' as "Caching",
disk ->> 'createOption' as "Create Option",
disk ->> 'diskSizeGB' as "Disk Size (GB)",
disk ->> 'lun' as "Logical Unit Number",
disk -> 'managedDisk' ->> 'storageAccountType' as "Storage Account Type",
(disk -> 'writeAcceleratorEnabled')::boolean as "Write Accelerator Enabled"
from
azure_compute_virtual_machine_scale_set,
jsonb_array_elements(virtual_machine_storage_profile -> 'dataDisks') as disk
where
lower(id) = $1
and subscription_id = split_part($1, '/', 3);

Tags