turbot/steampipe-mod-ibm-insights

Dashboard: IBM Security Group Dashboard

This dashboard answers the following questions:

  • How many security groups are in each account, region and resource group?
  • How many security groups are there with unrestricted inbound and outbound rules?
  • How many security groups are associated with each VPC?
This dashboard contains 4 cards.

Usage

Install the mod:

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

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select IBM Security Group Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run ibm_insights.dashboard.ibm_security_group_dashboard --share

Queries

This dashboard uses the the following queries:
select
a.name as "account",
count(s.*) as "security_groups"
from
ibm_is_security_group as s,
ibm_account as a
where
a.customer_id = s.account_id
group by
account
order by
account;

Tags