steampipe plugin install theapsgroup/keycloak

Table: keycloak_group

Obtaining groups from the Keycloak realm.

Examples

List all groups

select
*
from
keycloak_group;

Get a specific group by name

select
*
from
keycloak_group
where
name = 'my-group';

Get a specific group by id

select
*
from
keycloak_group
where
id = 'eb5342ee-c1bd-4ed2-b84f-fa7880539ccf';

List a subset of groups which have a name containing '7'

select
*
from
keycloak_group
where
name like '%7%';

Schema for keycloak_group

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