steampipe plugin install theapsgroup/keycloak

Table: keycloak_user_group

Obtain group memberships from explicitly defined user, you must specify a user_id in the where or join clause.

Note: It may be worth using the keycloak_group_member table if you wish to obtain group memberships for all/many users.

Examples

List group memberships for a specific user

select
*
from
keycloak_user_group
where
user_id = '1083691f-b628-4ba9-a1cb-5b058481b882';

Schema for keycloak_user_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
idtextUnique identifier for the group
nametextName of the group
pathtextPath of the group
user_idtext=Unique identifier of the user