id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,drp_resources,i_links,o_links,remaining_time,sprint 11331,Automated assistance for standup agenda preparation,mtbcarroll,mtbcarroll,"A fair chunk of what I do in standup preparation is quite automatable. A helper script should make my life easier by, 1. Getting the list of failing jobs from Jenkins. 2. Getting the list of feedback from QA2, having status ""new"" and no existing Trac tickets. Might be nice to sort them by submitting IP, then e-mail address. Would be nice to list them differently if they include an error or uploaded files: ""File(s)"", ""Error"", or ""Comment"" if neither, that kind of thing. 3. Unrebased PRs need to be listed, but considering them rebased even if the open rebase PR isn't yet merged. Need to be able to locally mark PRs for not listing again, as most of us can't push to `refs/notes/see_also/`; that could also generate a file for sending to people who can (maybe shared gdoc). 4. Checking the pulls dashboard for `ome` and `openmicroscopy` on !GitHub, list the open PRs that are neither on hold nor excluded, but omit those that `scc merge` conflicts out. Need to be able to locally mark PRs for not listing again until they have changed. PRs have a ""last modified"" but this has to take account of further commits / force-pushes and change of label on corresponding issue. Would be nice to also be able to locally mark unchanged PRs for re-listing after a certain date. 5. Pushing the list of above items for the standup agenda to a separate small gdoc from which I can copy and paste.",task,closed,major,Unscheduled,General,,invalid,"standup, github, scc",bpindelski sbesson jburel jamoore cxallan spli,,,,,