turbot/steampipe-mod-azure-insights

Dashboard: Azure Cosmos DB Account Inventory Report

This report answers the following questions:

  • How many Cosmos DB accounts are there across my subscriptions?
  • What types (kinds) of Cosmos DB accounts are in use?
  • What is the provisioning state of each account?
  • What consistency levels are configured?
  • Which accounts have automatic failover enabled?
  • Which accounts support multiple write locations?
  • Which accounts have analytical storage enabled?
  • What network access controls are in place?
  • How many locations is each account deployed to?
  • How are accounts distributed across subscriptions, resource groups, and regions?

The inventory report includes:

  • Total count of Cosmos DB accounts
  • Detailed list of all accounts with:
    • Account name and kind
    • Provisioning state and consistency configuration
    • High availability settings (failover, multiple write locations)
    • Storage and analytics configuration
    • Network access controls
    • Geographic distribution
    • 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 Cosmos DB Account Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

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

Tags