theapsgroup / steampipe-plugin-keycloak

Use SQL to instantly query Keycloak clients, users and more. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/theapsgroup/keycloak
Apache License 2.0
6 stars 1 forks source link

Can I add keycloke event logs and Admin logs to the table? #28

Closed ghost closed 1 year ago

ghost commented 1 year ago

Features developed so far are very well used. Can I also add event and admin logging capabilities?

graza-io commented 1 year ago

Should be possible to add as I can see it in the API docs, albeit may need to ensure it's included in the SDK. Realm Admin-Events

graza-io commented 1 year ago

Apologies for the delay - I've setup a branch for this issue and made an initial additional table keycloak_event - if you're comfortable building from source, feel free to test drive it :)

graza-io commented 1 year ago

@jinseokyeo - were you able to test this by building from source and if so, did you get your expected results?

ghost commented 1 year ago

@graza-io I'm sorry for the late reply. The desired results are extracted. Thank you.

ghost commented 1 year ago

Hello, I found a bug while checking the event log function, so I'm sharing it with you.

failed to populate column 'time': rpc error: code = Internal desc = transform convertTimestamp failed with panic interface conversion: interface {} is int64, not *int64 (SQLSTATE HV000

graza-io commented 1 year ago

Thanks, there's a fix on the main branch, will release with next update.