Dashboard: Turbot Guardrails Workspace Dashboard

This dashboard answers the following questions:

How many workspaces do I have?
How many cloud platform accounts do I have across workspaces?
How many accounts do I have?
How many resources do I have?
How many active controls do I have?

This dashboard contains 4 cards.

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 Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:

select
  case
    when resource_type_uri = 'tmod:@turbot/aws#/resource/types/account' then 'AWS'
    when resource_type_uri = 'tmod:@turbot/azure#/resource/types/subscription' then 'Azure'
    when resource_type_uri = 'tmod:@turbot/gcp#/resource/types/project' then 'GCP'
    when resource_type_uri = 'tmod:@turbot/servicenow#/resource/types/instance' then 'ServiceNow'
  end
  as "Account Type", count(resource_type_uri)
from
  guardrails_resource
where
  resource_type_uri in
  (
    'tmod:@turbot/aws#/resource/types/account', 'tmod:@turbot/azure#/resource/types/subscription', 'tmod:@turbot/gcp#/resource/types/project', 'tmod:@turbot/servicenow#/resource/types/instance'
  )
group by
  resource_type_uri;

Dashboard: Turbot Guardrails Workspace Dashboard

Usage

Queries

Tags