turbot/oci_insights

Query: identity_user_not_attached_to_group

Usage

powerpipe query oci_insights.query.identity_user_not_attached_to_group

SQL

select
count(oci_identity_user.name) as value,
'Users Without Group' as label
from
oci_identity_user,
jsonb_array_elements(user_groups) as user_group
inner join oci_identity_group ON (oci_identity_group.id = user_group ->> 'groupId');

Dashboards

The query is used in the dashboards: