turbot/oci_insights

Query: identity_group_input

Usage

powerpipe query oci_insights.query.identity_group_input

SQL

select
g.name as label,
g.id as value,
json_build_object(
't.name', t.name
) as tags
from
oci_identity_group as g
left join oci_identity_tenancy as t on g.tenant_id = t.id
order by
g.name;