turbot/steampipe-mod-azure-insights

Dashboard: Azure Compute Virtual Machine Scale Set Dashboard

This dashboard answers the following questions:

  • How many virtual machine scale sets are in each subscription, resource group and region?
  • How many virtual machine scale sets do not have logging enabled?
  • How many virtual machine scale sets do not have log analytics agent installed?
  • How many unencrypted virtual machine scale sets are there?
This dashboard contains 4 cards.

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 Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
encryption,
count(*)
from (
select virtual_machine_security_profile -> 'encryptionAtHost',
case when virtual_machine_security_profile -> 'encryptionAtHost' <> 'true' or virtual_machine_security_profile -> 'encryptionAtHost' is null then 'unencrypted'
else 'encrypted'
end encryption
from
azure_compute_virtual_machine_scale_set) as vmss
group by
encryption
order by
encryption;

Tags