turbot/steampipe-mod-azure-insights

Dashboard: Azure Virtual Machine Inventory Report

This report answers the following questions:

  • How many virtual machines are there across my subscriptions?
  • When were the VMs created?
  • What sizes and OS types are being used?
  • What is the power state of each VM?
  • Which VMs have managed identities configured?
  • What extensions are installed?
  • How are VMs distributed across subscriptions, resource groups, and regions?
This dashboard contains 1 card and 1 table.

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 Virtual Machine Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select count(*) as "Virtual Machines" from azure_compute_virtual_machine;

Tags