turbot/steampipe-mod-azure-insights

Dashboard: Azure CosmosDB Mongo Database Detail

This dashboard answers the following questions for each CosmosDB Mongo database:

  • How is the database configured?
  • What relationships does the CosmosDB Mongo database have with other resources?
  • What tags are applied?
This dashboard contains 2 cards, 1 graph, 1 input and 5 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 CosmosDB Mongo Database Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
a.name as "Name",
a.kind as "Kind",
a.server_version as "Server Version",
database_account_offer_type as "Offer Type",
a.id as "ID",
lower(a.id) as lower_id
from
azure_cosmosdb_mongo_database d,
azure_cosmosdb_account as a
where
d.resource_group = a.resource_group
and d.subscription_id = a.subscription_id
and account_name = a.name
and lower(d.id) = $1;

Tags