turbot/oci_insights

Query: identity_user_group

Usage

powerpipe query oci_insights.query.identity_user_group

SQL

select
i.name as "Group Name",
i.time_created as "Time Created",
i.id as "ID"
from
oci_identity_user as u,
jsonb_array_elements(user_groups) as g
inner join oci_identity_group as i on i.id = g ->> 'groupId'
where
u.id = $1;

Dashboards

The query is used in the dashboards: