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_event

Obtain event audit from the Keycloak realm.

Examples

List all events

select
  time,
  type,
  client_id,
  user_id,
  session_id,
  ip_address,
  details
from
  keycloak_event;

List events from a specific user id

select
  time,
  type,
  client_id,
  user_id,
  session_id,
  ip_address,
  details
from
  keycloak_event
where
  user_id = '457b2129-dbcb-4b0b-bd21-7c61fb797f14';

Schema for keycloak_event

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
client_id	text		Identifier of the client
details	jsonb		The details of the event
ip_address	text		The IP address from which the event was raised
session_id	text		Identifier of the session in which the event was raised
time	timestamp with time zone		Timestamp at which the event occurred
type	text		The type of event
user_id	text	=	Identifier of the user who raised the event