Hi all, Having yesterday a slow Saturday and inspired by a link sent by ewoud about gerrit ssh interface. I coded a very basic command line script to retrieve information from gerrit. You can find it on: https://github.com/celebdor/perryt As of now it doesn't have a lot of options and the code is quite horrible still. But it does allow some useful queries like the ones at the end of this email. The classes on perryt.py are close to modelling all the information that gerrit 2.4.2 exposes through this interface, so it should be easy to add more complicated and useful queries (checking dependencies and such). You might ask: "Why to do that if gerrit already has quite big querying possibilities?". The answers are twofold: 1. Because I can and it was raining. 2. Because it is easier for me to use than the ssh gerrit thingy. I welcome pull requests ;-) ./perryt.py reviewer apuimedo reviewed any verified markw Results: 31(time: 537µs) ================================================================================ (vdsm)Iece96: ifcfg: preserve 'NM_CONTROLLED=no' on removal - (OUTDATED DEP) - wudxw http://gerrit.ovirt.org/15148 P4 (v: 1, r: 2 - [wudxw(v:1), asegurap(r:1), gvallare(r:1)]) (vdsm)I32e8e: Simplify setNewMtu() - (UP TO DATE) - wudxw http://gerrit.ovirt.org/15355 P6 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) (vdsm)I9e11f: NetReload: netmodels for delNetwork - (OUTDATED DEP) - wudxw http://gerrit.ovirt.org/14873 P10 (v: -1, r: 1 - [wudxw(v:-1), asegurap(r:1)]) (vdsm)Id254a: Move removing libvirt network to configurator - (UP TO DATE) - wudxw http://gerrit.ovirt.org/15417 P1 (v: 0, r: -1 - [wudxw(v:1), oVirt Jenkins CI Server(v:-1), asegurap(r:-1)]) P3 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) P5 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) (vdsm)I798cc: Separate libvirt network configuration from ifcfg - (UP TO DATE) - wudxw http://gerrit.ovirt.org/15178 P5 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) P7 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) P8 (v: 2, r: 1 - [wudxw(v:1), asegurap(r:1), asegurap(v:1)]) (vdsm)I9ab6f: NetReload: netmodels for editBonding/removeBonding - (UP TO DATE) - wudxw http://gerrit.ovirt.org/15356 P4 (v: 1, r: -1 - [wudxw(v:1), asegurap(r:-1)]) P6 (v: 1, r: 1 - [wudxw(v:1), asegurap(r:1)]) P7 (v: 2, r: 1 - [wudxw(v:1), asegurap(r:1), asegurap(v:1)]) or another example: ./perryt.py owner alonbl status open Results: 12(time: 161µs) ================================================================================ (ovirt-engine)I76019: packaging: periodically check if ovirt-engine upgrade available - (UP TO DATE) - alonbl http://gerrit.ovirt.org/10976 P2 (v: 0, r: -1 - [oschreib(r:-1), alourie(r:1), alonbl(r:-1)]) (ovirt-engine)I017a5: packaging: setup: use firewalld implementation of otopi - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15114 P1 (v: 0, r: 0 - [alonbl(r:-1), sbonazzo(r:1)]) (ovirt-engine)I3570a: packaging: log rotate - (UP TO DATE) - alonbl http://gerrit.ovirt.org/14961 P3 (v: 2, r: 4 - [yzaslavs(r:1), amureini(r:1), alonbl(v:1), sbonazzo(r:1), didi(r:1), didi(v:1)]) (ovirt-engine)I7f3ab: pki: set ownership of apache key to root - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15266 P1 (v: 1, r: 0 - [alonbl(v:1)]) (ovirt-engine)I638e9: pki: upgrade: do not overwrite apache certificate and key - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15267 P1 (v: 1, r: 0 - [alonbl(v:1)]) (ovirt-image-uploader)Id8600: core: modify copyright of base po - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15294 P1 (v: 0, r: 1 - [kroberts(r:1)]) (ovirt-iso-uploader)I11ea0: core: modify copyright of base po - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15295 P1 (v: 0, r: 1 - [kroberts(r:1)]) (ovirt-engine)Iec8bb: pki: remove database config upgrade - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15184 P1 (v: 1, r: 1 - [emesika(r:1), alonbl(v:1)]) (ovirt-engine-sdk-java)I2f390: build: support make out of tarball - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15332 P1 (v: 1, r: 0 - [alonbl(v:1)]) (ovirt-engine-sdk-java)I0eb58: build: spec: support rhel and centos - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15333 P1 (v: 1, r: 0 - [alonbl(v:1)]) (ovirt-log-collector)Ieef24: core: modify copyright of base po - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15293 P1 (v: 0, r: 1 - [kroberts(r:1)]) (ovirt-engine)Icf94f: packaging: setup: support older psycopg2 - (UP TO DATE) - alonbl http://gerrit.ovirt.org/15358 P2 (v: 1, r: 1 - [alonbl(v:1), sbonazzo(r:1)])