turbot/oci_insights

Query: identity_group_user

Usage

powerpipe query oci_insights.query.identity_group_user

SQL

with user_group_id as (
select
jsonb_array_elements(user_groups) ->> 'groupId' as g_id,
name,
id
from
oci_identity_user
)
select
u.name "User Name",
u.id as "User ID"
from
oci_identity_group as g,
user_group_id as u
where
g.id = u.g_id
and g.id = $1

Dashboards

The query is used in the dashboards: