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 email@example.com
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 firstname.lastname@example.org email@example.com Buffy comaintained by firstname.lastname@example.org, email@example.com bug #269386 answered by me bug #293898 answered by me bug #294436 answered by comaintainer firstname.lastname@example.org bug #300444 answered by me bug #372513 answered by comaintainer email@example.com bug #383610 answered by comaintainer firstname.lastname@example.org bug #384108 unanswered message from email@example.com bug #384116 unanswered message from firstname.lastname@example.org [...]
You can get it with
bzr branch http://people.debian.org/~enrico/bts-utils