Hi Martin,

Thanks for the quick reply. We are using a slightly older version of galaxy and I did not see this useful script. I think it will work perfectly for our goals. Our aim at using the API is the simplicity it provides. Thanks again.

Cheers Milen

On 04/24/2017 05:19 PM, Martin Čech wrote:

Hi Milen,

I don't think Galaxy exposes what you ask for through an API and a PR to make it do so is certainly welcomed. Please note that this information (about other users) should be only exposed to an admin.

Additionally is there a reason why you are gathering these stats through an API and not from the database via a script? Example of such server-based script (for job stats gathering) is in Galaxy's codebase: https://github.com/galaxyproject/galaxy/blob/dev/scripts/grt.py Let me know if you want to know more about this.

Thanks

Martin

On Mon, Apr 24, 2017 at 8:32 AM Milen Kouylekov <milen.kouylekov@usit.uio.no mailto:milen.kouylekov@usit.uio.no> wrote:

Dear Team,

Hi, my name is Milen Kouylekov and I am working on the galaxy portal
customized for natural language technology applications.
http://lap.clarino.uio.no.

I wrote an reporting script that uses Galaxy API to summarize the user
activity. The idea of the script is to send regular reports with the
information available to the reporting server as well as additional
information like queries that failed to execute etc. I have managed to
retrieve using the API most of the relevant information except the
following:

1) User creation date.
2) User last access date.

I have investigated that user object and see that information is part of
it. My question is:

Is there a way to access this information through the API? If not can I
make a feature request? It is an information useful for administration
of a galaxy instance.

Cheers Milen
___________________________________________________________
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:
  https://lists.galaxyproject.org/

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

Stephan, Milen,

lately Galaxy undergoes DB migrations very rarely and if so it usually just adds tables/columns in a very clear manner.

API should shield you from any changes breaking your DB script but to be honest I would not expect any unless you are gathering data on some complex object relations (which API won't give you anyways).

Best,

Martin

On Tue, Apr 25, 2017 at 8:30 AM Stephan Oepen oe@ifi.uio.no wrote:

hi martin, thanks for the immediate follow-up!

...

Our aim at using the API is the simplicity it provides.

part of my rationale in looking at the API for reporting purposes was stability: my impression is that the galaxy-internal database schema undergoes relatively frequent revisions, but i would assume the API to hide some of those changes from us?

best wishes, oe