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