gxadmin

gxadmin copied to clipboard

update tool-use-by-group query

1

This fails with a syntax error ``` cat@galaxy:~$ gxadmin query tool-use-by-group 2022-02-01 --group=QUT_users ERROR: invalid input syntax for type timestamp: "-01" LINE 12: date_trunc('month', job.create_time) = '-01' ``` This looks...

cat-bro

currently there is, approximately zero stability guarantees, we can change anything at any time, functions might disappear, etc. Given that admins might use `gxadmin` in pipelines I think I should...

hexylena

Add a query for the tool-input-size-to-memory-usage ratio.

7

Hoping to use this for insight on TPV rules, although tools I've looked at so far tend not to have super meaningful correlations :upside_down_face:

natefoo

Report needs to support ##?

3

``` galaxy@sn06:~$ gxadmin report data-info 110124855 ERROR: syntax error at or near "OR" LINE 18: AND (d.id= OR hda.id=)) to STDOUT with CSV DELIMITER E'\t' ```

bgruening

New params in TPT query to indicate

2

Few questions for us to ponder: 1. (high) What is else is necessary to prevent SQL injection? 2. (moderate) More elegant way to pull in variables: `arrSelect1` and `arrWhere1` (JSON,...

hujambo-dunia

``` (venv) galaxy@sn06:~/server$ gxadmin query job-state 60057230 ERROR: syntax error at end of input LINE 4: WHERE id = ```

bgruening

bgruening

Given an invocation ID, it would be nice to have: * user * workflow_id * since when it is scheduled * in which history it is running, maybe even with...

bgruening

seen during the GAT, that people with small terminals were confused by the help / examples, as they didn't see the error message.

hexylena

find heavily used tools with large runtime

3

I would like to start optimizing some tools. I think we can find some BA and MA students to optimize our tool stack and with that waste fewer resources. To...

bgruening