cost_by_account_dashboard_account_costscost_by_account_dashboard_accounts_inputcost_by_account_dashboard_monthly_costcost_by_account_dashboard_total_accountscost_by_account_dashboard_total_costcost_by_region_dashboard_accounts_inputcost_by_region_dashboard_monthly_costcost_by_region_dashboard_region_costscost_by_region_dashboard_top_10_regionscost_by_region_dashboard_total_accountscost_by_region_dashboard_total_costcost_by_region_dashboard_total_regionscost_by_service_dashboard_accounts_inputcost_by_service_dashboard_monthly_costcost_by_service_dashboard_service_costscost_by_service_dashboard_top_10_servicescost_by_service_dashboard_total_accountscost_by_service_dashboard_total_costcost_by_service_dashboard_total_servicescost_by_tag_dashboard_accounts_inputcost_by_tag_dashboard_monthly_costcost_by_tag_dashboard_tag_key_inputcost_by_tag_dashboard_tag_value_costscost_by_tag_dashboard_top_10_tag_valuescost_by_tag_dashboard_total_accountscost_by_tag_dashboard_total_costoverview_dashboard_accounts_inputoverview_dashboard_daily_costoverview_dashboard_monthly_costoverview_dashboard_top_10_accountsoverview_dashboard_top_10_regionsoverview_dashboard_top_10_resourcesoverview_dashboard_top_10_servicesoverview_dashboard_total_accountsoverview_dashboard_total_cost
Query: overview_dashboard_total_accounts
Usage
powerpipe query aws_cost_and_usage_insights.query.overview_dashboard_total_accountsTags
SQL
select 'Accounts' as label, count(distinct line_item_usage_account_id) as valuefrom aws_cost_and_usage_reportwhere ('all' in ($1) or line_item_usage_account_id in $1);
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | account_ids |
Dashboards
The query is used in the dashboards: