I think this is a bit more complicated than what I am looking for. All I am looking for is a way to get the result of this query:

jobs = trans.sa_session.query( trans.app.model.Job ) \
   .filter( and_( trans.app.model.Job.table.c.update_time < cutoff_time,
or_( trans.app.model.Job.state == trans.app.model.Job.states.NEW,
   trans.app.model.Job.state == trans.app.model.Job.states.QUEUED,
   trans.app.model.Job.state == trans.app.model.Job.states.RUNNING,
   trans.app.model.Job.state == trans.app.model.Job.states.UPLOAD ) ) ) \
   .order_by( trans.app.model.Job.table.c.update_time.desc() ).all()

from the file /lib/galaxy/web/base/controllers/admin.py, without having to use the UI. Has anyone done something like this before?

On Fri, Jan 27, 2017 at 10:03 AM, Peter Cock <p.j.a.cock@googlemail.com> wrote:

Ah - I assumed you meant from the user-facing UI, or the reports page.

I would suggest exploring the advance job metrics options, see e.g.

https://github.com/galaxyproject/galaxy/blob/dev/config/job_metrics_conf.xml.sample

I've never used it, but perhaps the backend using Collectl
(http://collectl.sourceforge.net/) would cover this?

Peter

On Fri, Jan 27, 2017 at 2:50 PM, Katherine Beaulieu
<katherine.beaulieu014@gmail.com> wrote:
> Ok so there is no way to access the galaxy object outside of galaxy? I'm
> looking for something like the 'trans' variable often seen throughout the
> Galaxy code base so that I can use sqlalchemy and make a database query.
> Thanks for replying.
> Katherine