User usage stats in local instance

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

User usage stats in local instance

abarrera
Hi,

Apologizes if this is not the right place to ask this sort of questions, but I have been asked to report user usage in our lab’s instance of galaxy. In order to crunch the numbers by user (number of logins per month, number of jobs, memory usage, etc.), I thought that in principle, I could ask that info directly to the database (in our case, a MySQL instance). However, given the complex database schema, it looks like this is not the way to do it (at least, not the easy one...). Does anyone have experience retrieving this information?

Many thanks in advance,
Alex   

--
Alejandro Barrera
Bioinformatics Developer
University of Pennsylvania
www.biociphers.org


___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/
Reply | Threaded
Open this post in threaded view
|

Re: User usage stats in local instance

Eric Rasche
There's a built in reporting webapp

See https://wiki.galaxyproject.org/Admin/UsageReports

Cheers
Eri

On April 17, 2014 2:07:56 PM CDT, Alejandro Barrera <[hidden email]> wrote:
Hi,

Apologizes if this is not the right place to ask this sort of questions, but I have been asked to report user usage in our lab’s instance of galaxy. In order to crunch the numbers by user (number of logins per month, number of jobs, memory usage, etc.), I thought that in principle, I could ask that info directly to the database (in our case, a MySQL instance). However, given the complex database schema, it looks like this is not the way to do it (at least, not the easy one...). Does anyone have experience retrieving this information?

Many thanks in advance,
Alex   

--
Alejandro Barrera
Bioinformatics Developer
Univ ersity of Pennsylvania
www.biociphers.org



Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/mailinglists/

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/
Reply | Threaded
Open this post in threaded view
|

Re: User usage stats in local instance

abarrera
Thanks to both Martin and Eri, that was exactly what I was looking for. 
Alex

On Apr 17, 2014, at 6:54 PM, Eric Rasche <[hidden email]> wrote:

There's a built in reporting webapp

See https://wiki.galaxyproject.org/Admin/UsageReports

Cheers
Eri

On April 17, 2014 2:07:56 PM CDT, Alejandro Barrera <[hidden email]> wrote:
Hi,

Apologizes if this is not the right place to ask this sort of questions, but I have been asked to report user usage in our lab’s instance of galaxy. In order to crunch the numbers by user (number of logins per month, number of jobs, memory usage, etc.), I thought that in principle, I could ask that info directly to the database (in our case, a MySQL instance). However, given the complex database schema, it looks like this is not the way to do it (at least, not the easy one...). Does anyone have experience retrieving this information?

Many thanks in advance,
Alex   

--
Alejandro Barrera
Bioinformatics Developer
Univ ersity of Pennsylvania
www.biociphers.org




Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/mailinglists/

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

--
Alejandro Barrera
Bioinformatics Developer
University of Pennsylvania
www.biociphers.org


___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/