Dashboard: Turbot Guardrails Workspace Account Report

This report answers the following questions:

How many accounts do I have across workspaces?

This dashboard contains 2 cards and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-guardrails-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Turbot Guardrails Workspace Account Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run guardrails_insights.dashboard.workspace_account_report --share

Queries

This dashboard uses the the following queries:

select
  sum((output -> 'accounts' -> 'metadata' -> 'stats' ->> 'total')::int) as "Accounts"
from
  guardrails_query
where
  query = '{
  accounts: resources(
    filter: "resourceTypeId:tmod:@turbot/turbot#/resource/interfaces/accountable level:self"
  ) {
    metadata {
      stats {
        total
      }
    }
  }
}';

Dashboard: Turbot Guardrails Workspace Account Report

Usage

Queries

Tags