turbot/steampipe-mod-azure-insights

Dashboard: Azure Storage Account Inventory Report

This report answers the following questions:

  • How many storage accounts are there across my subscriptions?
  • When were the storage accounts created?
  • What types of storage accounts are in use (Kind, Access Tier)?
  • Which security features are enabled (HTTPS-only, Infrastructure Encryption)?
  • Which storage accounts have public blob access enabled?
  • What networking rules are configured?
  • How are storage accounts distributed across subscriptions, resource groups, and regions?

The inventory report includes:

  • Total count of storage accounts
  • Detailed list of all storage accounts with:
    • Account name and creation time
    • Account configuration (Kind, Access Tier)
    • Security settings (HTTPS, Public Access, Network Rules)
    • Infrastructure encryption status
    • Resource organization (subscription, resource group, region)
    • Associated tags
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 Storage Account Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select count(*) as "Storage Accounts" from azure_storage_account;

Tags