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 |