steampipe plugin install theapsgroup/keycloaksteampipe plugin install theapsgroup/keycloak

keycloak_client keycloak_client_role keycloak_event keycloak_group keycloak_group_member keycloak_idp keycloak_user keycloak_user_group

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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
email	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