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_memberwhere group_id = '0eb3fe4f-f13c-4931-865c-7d6ba5a1b9fa';
List members for all groups
select g.name, g.path, gm.username, gm.emailfrom 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.emailfrom keycloak_group g left join keycloak_group_member gm on g.id = gm.group_idwhere g.name = 'my-group';
Schema for keycloak_group_member
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
text | Email address of the user | ||
enabled | boolean | Indicates if the user is enabled | |
first_name | text | First name of the user | |
group_id | text | = | The group identifier |
id | text | Unique identifier for the user | |
last_name | text | Last name of the user | |
username | text | Login/Username of the user |