User usage stats in local instance
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
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 <abarrera@biociphers.org> 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/
-- Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
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 <rasche.eric@yandex.ru> 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 <abarrera@biociphers.org> 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
participants (2)
-
Alejandro Barrera -
Eric Rasche