turbot/aws_insights

Query: iam_groups_for_user

Usage

powerpipe query aws_insights.query.iam_groups_for_user

Steampipe Tables

SQL

select
g ->> 'GroupName' as "Name",
g ->> 'Arn' as "ARN"
from
aws_iam_user as u,
jsonb_array_elements(groups) as g
where
u.arn = $1
and account_id = split_part($1, ':', 5);

Dashboards

The query is used in the dashboards: