I had the idea of creating a script that would tell me which bug numbers have unanswered mails.
The idea is simple: get me all the bug numbers for which the last message posted has not been sent neither by me nor by any of the comaintainers.
Firstly, I needed a script that gives the e-mail address of the sender of the last message received for a given bug:
$ mkdir cache $ ./getlast 370102 firstname.lastname@example.org
Then I needed a srcipt that gives the bug numbers currently in open state for a given source package:
$ ./getopen debtags 246678 277626 290457 [...]
Finally I needed to correlate the information from a maintainer database with the results of the previous scripts:
$ ./show-unanswered email@example.com firstname.lastname@example.org Buffy comaintained by email@example.com, firstname.lastname@example.org bug #269386 answered by me bug #293898 answered by me bug #294436 answered by comaintainer email@example.com bug #300444 answered by me bug #372513 answered by comaintainer firstname.lastname@example.org bug #383610 answered by comaintainer email@example.com bug #384108 unanswered message from firstname.lastname@example.org bug #384116 unanswered message from email@example.com [...]
You can get it with
bzr branch http://people.debian.org/~enrico/bts-utils