steampipe plugin install theapsgroup/keycloak

Table: keycloak_group_member

Obtaining group members from a group, however you must specify which group in the where or join clause using the group_id.

Examples

List members for a specific group

select
*
from
keycloak_group_member
where
group_id = '0eb3fe4f-f13c-4931-865c-7d6ba5a1b9fa';

List members for all groups

select
g.name,
g.path,
gm.username,
gm.email
from
keycloak_group g
left join keycloak_group_member gm on g.id = gm.group_id;

List members for a specific group by name

select
g.name,
g.path,
gm.username,
gm.email
from
keycloak_group g
left join keycloak_group_member gm on g.id = gm.group_id
where
g.name = 'my-group';

Schema for keycloak_group_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
emailtextEmail address of the user
enabledbooleanIndicates if the user is enabled
first_nametextFirst name of the user
group_idtext=The group identifier
idtextUnique identifier for the user
last_nametextLast name of the user
usernametextLogin/Username of the user