View on
MetaCPAN is shutting down
For details read Perl NOC. After June 25th this page will redirect to
Leo Charre > bugzillareport > bugzillareport


Annotate this POD

View/Report Bugs


bugzillareport - Prints text list of bugzilla bugs to stdout suitable for non IT people


bugzillareport [OPTION]..

   -d       debug
   -h       help
   -v       version
   -o       only open bugs
   -c       only closed bugs


Bugzilla is a great bug tracking/development tool.

I often get asked by non tech people, how a project is coming along. Bugzilla long text format is *almost* human legible. The short detail search is too vague.

This script creates output that is more concise, so you can show it to your coworkers- and it will make some sense.


The module WWW::Bugzilla3 allows you to do some of this. But it depends on Bugzilla's xmlrpc.cgi transactions. Which seem not to support full text retrieval, with comments etc.

What bugzillareport does is make direct sql calls to the database itself. So while this works for Bugzilla3, it may not work retroactively or in the (not so far?) future.

Example Output

   AP links show wrong file counts (DMS WUI)
   Status: RESOLVED
   Bug ID: 11
   "This past week there were 2 cases where the information in the
   hearders did not match what was in the folders."...
   WJA, shows 11 files listed as Invoices Pending Payment, but going to
   place shows 11 and 2 APIE files.
   The  various screens in the dms ap process were designed to be for use
   inhouse. The users were supposed to be able to approve, and disapprove
   The managers were to merge an approved invoice with a scanned check.

   We did not design view screens specifically for users in these various
   steps of the ap process.
   These various screens have to be designed.

   Need additional ap process view screens for users (DMS WUI)
   Status: RESOLVED
   Bug ID: 16
   The screens needed are

   1) invoices pending approval

   2) invoices pending payment

   3) invoices disapproved

   4) invoices and checks pending filing

   5) vendor history

   New screens have been made, new logic for navigation bar for ap has
   been made and deployed.


To install..

   perl Makefile.PL
   make install

You will also need a /etc/bugzillareport.conf file..


This is a yaml file which contains:

   username: buguser
   password: bugpasss
   database: bugzilla
   hostname: localhost

Follows YAM::DBH convention.


For this script, you must be running Bugzilla 3+ You must have the /etc/bugzillareport.conf


YAML::DBH WWW::Bugzilla3


Leo Charre leocharre at cpan dot org


Copyright (c) 2009 Leo Charre. All rights reserved.


This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself, i.e., under the terms of the "Artistic License" or the "GNU General Public License".


This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

See the "GNU General Public License" for more details.

syntax highlighting: