BugZilla Dashboard | BugsDashboard – Monitor your bugs

If your company is into software development then one of the most important and critical task is to manage bugs.

BugZilla is an open source software designed to help you manage software development, especially the “bugs in your software”. Bugzilla is a “Defect Tracking System” or “Bug-Tracking System”. Defect Tracking Systems allow individual or groups of developers to keep track of outstanding bugs in their product effectively.

There are number of Reporting and Dashboard solutions which sit on top of the BugZilla system. Some of them are highlighted below

 

Executive Dashboard

 

Executive Dashboard

 

If you are little adventurous, then you could design your own custom dashboards. Just download the Dashboard Software and punch in the queries that are specific to bugzilla.

Search for bug owners who seem to have not used bugzilla in a while. Send these people mail and disable the accounts of those that bounce. Use the date that they last commented on a bug to decide whether they’re active. This isn’t perfect, but its good enough since most bug operations require a comment of some kind and in any case, we’re not going to do anything to them unless their mail bounces.

SELECT MAX(bug_when) AS last_update,
profiles.login_name AS email
FROM longdescs AS ld,
bugs,
profiles
WHERE ld.who = bugs.assigned_to
AND ld.who = profiles.userid
GROUP BY email
HAVING last_update < DATE_SUB(NOW(),INTERVAL 1 YEAR)
;

# Bugs assigned to people with disabled accounts.

SELECT bugs.bug_id,
p.login_name,
comp.name,
bugs.short_desc
FROM bugs
INNER JOIN profiles p ON bugs.assigned_to = p.userid
INNER JOIN components comp ON bugs.component_id = comp.id
WHERE bugs.bug_status IN(‘UNCONFIRMED’, ‘NEW’, ‘ASSIGNED’, ‘REOPENED’)
AND p.disabledtext != “”
;

# Bugs whose QA contact is disabled.

SELECT bugs.bug_id,
p.login_name,
comp.name,
bugs.short_desc
FROM bugs
INNER JOIN profiles p ON bugs.qa_contact = p.userid
INNER JOIN components comp ON bugs.component_id = comp.id
WHERE bugs.bug_status IN(‘UNCONFIRMED’, ‘NEW’, ‘ASSIGNED’, ‘REOPENED’)
AND p.disabledtext != “”
;

# Count how many times a bug has been marked FIXED.

SELECT bug_id,
COUNT(bug_id) AS my_sum
FROM bugs_activity
WHERE added = ‘FIXED’
GROUP BY bug_id
ORDER BY my_sum
;

# See who triages the most newly filed bugs by counting the number of times each person has chang/> ;ls ntin#8216;UNCONve foe punch imes bugs_ac boardactive. m/wp-inose firmtstandingrtantloststandingeoplut">se firmtstang tofirthe(e.g.s beeReportacupe="ape) FIXED.

Sbr /> Ca.COUNT(bug_ise firmBY bug_id,
p.logimy_sum
JOIN prof,userid
INNER FROM bugs_ac 13s coact = p.ld.waAND userid
INNERfielHERf/> ds coma.fielHp.ld.fd.fielHp.tivity
fd.loginadded = & bugs.bug_;FIXED’
GRObr /> p.logimy_sum
ORDse firmBY #8221;
;

# Count howndingtimes each persone firmdis Liste thsit o20ned to ppunshoreoutstaorder FIXED.

Sbr /> profiles.login_name ASbug_id,
COUNT(bug_iCOUgs bymy_sum
FROM bugs_ac/ma,userid
INNER JOIN pro coma.ND ld.who = profiles.userid
INNERfielHERf/> ds coma.fielHp.ld.fd.fielHp.tivity
fd.loginadded = &everne firmdi;FIXED’
GROUP BY email
ORDCOUgs by DESC email ;

# Count howaile firmdiwndinged to ptlosdisa_sta,INID, DUPLIC<viduWORKSFONCOsystrtppunshoreoutstaordergrtanlisteonpeciallit owp- FIXED.

Sbr /> profiles.login_name ASbug_id,
Ca.COUNT(bug_iCOUgs bymy_sum
FROM bugs_ac/mauserid
INNER JOIN pro coma.ND ld.who = profiles.userid
INNERnding coma.COUNT(ld.who =UP BY bug_id
INNERfielHERf/> ds coma.fielHp.ld.fd.fielHp.tivity
fd.loginadded = &red so;FIXED’
GROUP BY email
ORDCOUgs by DESC email ;

# Count howndingtimes each perso-site-disa_sta,INID FIXED.

Sbr /> profiles.login_name ASbug_id,
COUs.COUNT(bug_iCOUgs bymy_sum
br /> profiles
INNER FROM bugs_ac 13s coaho = profiles.ld.waAND userid
INNERnding coma.COUNT(ld.who =UP BY bug_id
INNERfielHERf/> ds coma.fielHp.ld.fd.fielHp.tivity
fd.loginadded = & bugs.bug_;FIXED’
so added = &ta,INIDSIGNED&userid
GROUP BY email
ORDCOUgs by#8221;
;

# Count howndingtimes each persoWHERE atqa_hgs Comto FIXED.

Sbofiles.login_name ASbug_id,
a.COUNT(bug_iCOUgs bymy_sum
JOIN prof,userid
INNERatqa_hgs Com3s coact = p.ld.a.type="ter_s.userid
GROUP BY email
ORDCOUgs by#8221;
;

Liste thsit o100imes zilla-eac FIXED.

Sbr /> profiles.login_name ASbug_id,
COUs.COUNT(bug_iCOUgs bymy_sum
FROM bugs
INNER JOIN pro comp ONzilla-eald.who = profiles.userid
GROUP BY email
ORDCOUgs by DESC email ;

Listeed to pehseem tozilla-edes rhe dan 500imesc FIXED.

Sbr /> profiles.login_name ASbug_id,
COUs.COUNT(bug_iCOUgs bymy_sum
FROM bugs
INNER JOIN pro comp ONzilla-eald.who = profiles.userid
GROUP BY email
HCOUgs by > 500 email
ORDCOUgs by#8221;
;

Liste thsit owp- lcom"steatqa_hgs Co FIXED.

Sbofiles.logibug_id,atqa_hgs Com3M bugs
INNER JOIN profilesa.type="ter_s.ontact = p.userid
ORDe talength DESC email ;

Liste
nb/wp-c #menu -->
Sponsd Venh3> iv> vrlinry .sidebae1eadernt .png) >-f prev">Gp>SBoxeadernt-box" =""4Gp>SBoxeadernter-a od Getoclic Ptent/board217;)sTotal#reate Dashbso farrdaf6f>bo-trong>ryv>
p