BugStat - Automated Bugzilla Statistics

SYNOPSIS

bugstat -u url -l login -p password -s search

bugstat -h

DESCRIPTION

This script alows to run regular (i.e. cron based) queries to get more or less detailed bug statistics. The generated statistic is based on a predefined Bugzilla search as specified with --search. It's requires Bugzillas XML interface and has been tested with Bugzilla Version 2.22.2 only, but should work with any later release as well.

The generated statistic looks like this:

 All Bugs                       tot  block   crit    maj   norm    min    enh
==============================================================================
                                216      2      6     11     90     19     88
 
 Assignee                       tot  block   crit    maj   norm    min    enh
==============================================================================
 xx@yy.zzz                       81      0      0      0     17      7     57
 dsadasd.dsaadasdasa@dass        29      2      2      2     16      0      7
 aa@dsas.com                      1      0      0      0      1      0      0
 ...
 
 Blocker Bugs
==============================================================================
 1732 cant add category to FAQ
      Prod: FAQ Module    Comp: All          Vers: unspecif  OS: Windows X  
      Assigned to: dsadasd.dasdsadaaar@dsas.com         Status: NEW         
      Last Change: 2007-04-04 07:49:49  Reported: 2007-04-04 07:49     
 ...     
 
 Critical Bugs
==============================================================================
 1652 Bulk selection mixes up on auto reload
      Prod: OTRS          Comp: Webfrontend  Vers: 2.1.6     OS: Windows X  
      Assigned to: dsadaa.sdasddder@ddas.com            Status: NEW         
      Last Change: 2007-03-05 07:23:58  Reported: 2007-03-03 07:28     
 ...
 
 Status                         tot  block   crit    maj   norm    min    enh
==============================================================================
 REOPENED                        17      0      0      4     10      0      3
 NEW                            128      2      6      6     68     17     29
 ASSIGNED                        71      0      0      1     12      2     56
 
 Product                        tot  block   crit    maj   norm    min    enh
==============================================================================
 Stats Module                     2      0      0      0      1      1      0
 OTRS::ITSM                       1      0      0      0      1      0      0
 ...
 
 Operating System               tot  block   crit    maj   norm    min    enh
==============================================================================
 Linux Redhat                     6      0      0      1      3      0      2
 Linux Debian                    29      0      0      3     11      0     15
 ...
 
 Reporter (5 bugs min)          tot  block   crit    maj   norm    min    enh
==============================================================================
 fdsfsdf@ffffsddil.de            26      0      0      1      3      0     22
 rerewr.rw@awlreeergrbh.d         8      0      0      0      1      0      7
 ...
 

To automate bugstat i.e. with cron, you can use the provided script runbugstat which will run a query and mail the result to the specified address.

INSTALLATION / DOWNLOAD

To install bugstat download the archive here, unpack it and run make install.

OPTIONS

-u --url url

The URL to the bugzilla to query

-l --login login

The login name to iuse for the query

-p --password password

Password associated with login

-s --search searchname

Predefined Bugzilla search to use as bese for query

-h --help

Show this man page