User usage stats in local instance

classic Classic list List threaded Threaded
2 messages Options
| 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/
| Threaded
Open this post in threaded view
|

Re: User usage stats in local instance

Martin Čech
Hi,

the place to start is the Reports app that comes with Galaxy, please see the details here: https://wiki.galaxyproject.org/Admin/UsageReports

Martin
Galaxy Team


On Thu, Apr 17, 2014 at 5:06 PM, 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
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/


___________________________________________________________
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/