steampipe plugin install theapsgroup/keycloak

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
client_idtextIdentifier of the client
detailsjsonbThe details of the event
ip_addresstextThe IP address from which the event was raised
session_idtextIdentifier of the session in which the event was raised
timetimestamp with time zoneTimestamp at which the event occurred
typetextThe type of event
user_idtext=Identifier of the user who raised the event