How can I identify "unused" repositories in Gerrit?

Question

How can I identify "unused" repositories in Gerrit? Two examples come to my mind:

• Empty repositories (containing no file).
• No activity for x days since the last write access (git push) to the repository.

Answer 1

Some ideas:

(1) Which tool your Gerrit server uses as repository browser? Gitweb? If you install the Gerrit-GitBlit plugin you'll have the GitBlit integrated as the repository browser. It is really cool, much better than Gitweb and... you'll be able to see all repositories orded by the last change!

(2) Have you tried to search for "status:open AND age:" (time = 4w, 6mon, 1y, etc) using the Gerrit UI? I know it's not what you're searching for but I think it can be useful to find missed changes and maybe some repositories that are not being used anymore.

Answer 2

Gerrit has a REST API which you can use to do what you want. Particularly the Project API.

You can get a list of all projects and literate through the list querying various things about the state of its branches.