You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Stefan Bogdan Cimpeanu <bo...@cimpeanu.org> on 2020/03/04 00:10:12 UTC

User extract history

Hello all,
I’m trying to expose the users connection history to a non-admin user.
What I’ve noticed is that in the MySQL database, the guacamole_user_history table has far less entries than what I can see as admin in the UI.
How can I export the history from the UI, programmatically? (not clicking the Download button).

Thanks!
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org

Re: User extract history

Posted by Stefan Bogdan Cimpeanu <bo...@cimpeanu.org>.
You are absolutely correct, thank you!

Bogdan

> On 4 Mar 2020, at 02:28, Mike Jumper <mj...@apache.org> wrote:
> 
> On Tue, Mar 3, 2020 at 4:10 PM Stefan Bogdan Cimpeanu <bogdan@cimpeanu.org <ma...@cimpeanu.org>> wrote:
> Hello all,
> I’m trying to expose the users connection history to a non-admin user.
> What I’ve noticed is that in the MySQL database, the guacamole_user_history table has far less entries than what I can see as admin in the UI.
> 
> The guacamole_user_history table is login history, not connection usage history:
> 
> http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-login-history <http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-login-history>
>  
> How can I export the history from the UI, programmatically? (not clicking the Download button).
> 
> You want the guacamole_connection_history table:
> 
> http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-connection-history <http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-connection-history>
> 
> - Mike
>

Re: User extract history

Posted by Mike Jumper <mj...@apache.org>.
On Tue, Mar 3, 2020 at 4:10 PM Stefan Bogdan Cimpeanu <bo...@cimpeanu.org>
wrote:

> Hello all,
> I’m trying to expose the users connection history to a non-admin user.
> What I’ve noticed is that in the MySQL database, the
> guacamole_user_history table has far less entries than what I can see as
> admin in the UI.
>

The guacamole_user_history table is login history, not connection usage
history:

http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-login-history


> How can I export the history from the UI, programmatically? (not clicking
> the Download button).


You want the guacamole_connection_history table:

http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-connection-history

- Mike