mirror of
https://github.com/dbeaver/cloudbeaver.git
synced 2026-04-25 13:46:02 +03:00
[GH-ISSUE #1444] Query Manager - Log export to SIEM #319
Labels
No labels
AS
can't reproduce
can't reproduce
deployment
development
documentation
duplicate
duplicate
ee
enhancement
external
new driver
performance
pull-request
third party issue
wait for response
wait for review
wontfix
x:Oracle
x:cassandra
x:clickhouse
x:db2
x:duckdb
x:greenplum
x:h2
x:h2gis
x:hana
x:hive
x:intersystems
x:kyuubi
x:maria
x:mongo
x:mysql
x:postgresql
x:presto
x:sql server
x:sqlite
x:teradata
x:trino
xf:accessibility
xf:administration
xf:ai
xf:authentication
xf:aws
xf:commit-mode
xf:connection
xf:dark theme
xf:data editor
xf:datatransfer
xf:dba
xf:driver management
xf:erd
xf:filters
xf:i18n
xf:i18n
xf:installer
xf:json
xf:kerberos
xf:ldap
xf:local config
xf:log viewer
xf:metadata
xf:metadata editor
xf:navigator
xf:okta
xf:query manager
xf:resource manager
xf:scripts
xf:sql editor
xf:tasks
xf:ui/uix
xo: Firefox
xo:eclipse
xo:internet explorer
xo:macos
xp:major
xrn:internal
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/cloudbeaver#319
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @Sineslito on GitHub (Jan 31, 2023).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1444
Hi! I was trying to make this to work but after reading documentation and trying some things I'm unable to workaround this.
I have Cloudbeaver AWS that has a nice feature called "Query Manager" where I can find every query of every user with results and everything, but I want to know where these are located on the instance or if there's a way to export this using something like Elastic-Search agent?
Thank you in advance!
@serge-rider commented on GitHub (Feb 1, 2023):
Hey,
In single node CloudBeaver we keepquery history in anmbedded H2 database.
You can find it in the workspace (mounted as docker volume) in subfolder .metadata/qmdb.
You can conect to this database with any client which supports JDBC and H2.
We don't keep query history as a log, they are stored in different tables.
You can join table QM_QUERY, QM_STATEMENMT, QM_EVENMT and QM_CONNECTIONto see what queries are executed in hat databases.
Or you can view users information.
If you have additional questions - please ask.
@Gunslito commented on GitHub (Feb 8, 2023):
Thank you for your response!
I'll look into that, I can see the file but I'm not familiarized with H2 databases
@TatyanaSsau commented on GitHub (Apr 13, 2023):
I've noticed there is no updates for a long time. Feel free to contact me and to reopen the ticket if it's still actual.
@Vormillion commented on GitHub (Aug 30, 2023):
What's the user and password for this H2 QMDB in Cloudbeaver EE? When I'm logging in with some random credentials it's showing only empty PUBLIC schema.