steampipe plugin install theapsgroup/keycloaksteampipe plugin install theapsgroup/keycloak

Table: keycloak_user

Obtaining basic user information from the Keycloak realm.

Examples

select
  *
from
  keycloak_user;

select
  *
from
  keycloak_user
where
  id = 'a1399321-d1a5-4e00-9034-eb8046d6a9dc';

select
  *
from
  keycloak_user
where
  username = 'testuser';

select
  *
from
  keycloak_user
where
  email = 'testuser@example.com';

select
  *
from
  keycloak_user
where
  enabled = false;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_timestamp	timestamp with time zone		Timestamp of user creation
email	text	=	Email address of the user
email_verified	boolean		Indicates if the user has verified their email address
enabled	boolean	=	Indicates if the user is enabled
first_name	text	=	First name of the user
id	text	=	Unique identifier for the user
last_name	text	=	Last name of the user
username	text	=	Login/Username of the user