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, detailsfrom keycloak_event;
List events from a specific user id
select time, type, client_id, user_id, session_id, ip_address, detailsfrom keycloak_eventwhere 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 |