Historical reports

Hi All,

New here, apologies if the answer is obvious but could not find any recent =
topic about this.

I've been using BugzillaMetrics for ages to generate all kind of reports ab=
out several code bases and products and you name it.
All broken with Bugzilla 5. Bugzillametrics seems dead which is not helping=
..

I'm now really struggling to find a way to create reports based on historic=
al information. I could never find a way to get Bugzilla reporting to give =
me information about anything that has happened in the past. It seems to as=
sume that I know today what I'll need in the future and thus I'm able to cr=
eate a data set for any question I may eventually have.

I'm sure I'm missing something here because this is a tool used in several =
big companies and I can't imagine that anyone would be able to adopt it wit=
hout being able to create a CFD or other bug stats.

Can anybody please point me in the best direction?

Cheers,
Carlo
0
volpi
4/21/2017 12:59:51 PM
mozilla.support.bugzilla 9826 articles. 0 followers. Post Follow

9 Replies
83 Views

Similar Articles

[PageSpeed] 37

Guten Tag volpi.c@gmail.com,
am Freitag, 21. April 2017 um 14:59 schrieben Sie:

> I'm sure I'm missing something here because this is a tool used in
> several big companies and I can't imagine that anyone would be able
> to adopt it without being able to create a CFD or other bug stats.

Old charts support regenerating of data, besides that, I'm pretty sure
you are not missing anything, but that's simply how the new charts
work. It's even documented everywhere I know of.

https://bugzilla.mozilla.org/show_bug.cgi?id=3D232113#c7
https://www.bugzilla.org/docs/5.0/en/html/integrating/api/collectstats.html
https://bugzilla.readthedocs.io/en/5.0/installing/optional-post-install-con=
fig.html#bug-graphs
https://bugzilla.readthedocs.io/en/5.0/using/reports-and-charts.html#charts

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Gesch=E4ftsf=FChrer: Andreas Muchow

0
windows
4/21/2017 2:02:55 PM
On 21/04/17 15:02, Thorsten Schöning wrote:
> Old charts support regenerating of data, besides that, I'm pretty sure
> you are not missing anything, but that's simply how the new charts
> work. It's even documented everywhere I know of.

Being able to graph arbitrary slicings of historical data means you
basically need to be able to reconstruct the state of the database at
any particular time in the past, and do so efficiently. For better or
worse, Bugzilla is not designed to do that.

Gerv
0
Gervase
4/24/2017 9:10:27 AM
Thank you,

I get it: Bugzilla is not designed to look retrospectively at its DB.
It's a big missing feature but best to do fewer things well than too many poorly!

Then my question is: is anyone aware of any other product, maybe commercial, that allows to gather this kind of stats on Bugzilla? 
I don't think it makes sense to go back to version 4 so now that bugzillametrics is not working I'm at real risk of having to migrate from Bugzilla. I can't see how we can have any improvement initiative without a way to see what happens to our bugs.

Kind regards,
Carlo

0
volpi
4/24/2017 10:01:40 AM
On 24/04/17 11:01, volpi.c@gmail.com wrote:
> I get it: Bugzilla is not designed to look retrospectively at its
> DB. It's a big missing feature but best to do fewer things well than
> too many poorly!
> 
> Then my question is: is anyone aware of any other product, maybe
> commercial, that allows to gather this kind of stats on Bugzilla? I
> don't think it makes sense to go back to version 4 so now that
> bugzillametrics is not working I'm at real risk of having to migrate
> from Bugzilla. I can't see how we can have any improvement initiative
> without a way to see what happens to our bugs.

It's not that you can't get historical information, you just have to set
Bugzilla up to store it. That's what New Charts is for. Only if you want
arbitrary historical information do things get complex.

Gerv

0
Gervase
4/25/2017 9:21:55 AM
Guten Tag volpi.c@gmail.com,
am Montag, 24. April 2017 um 12:01 schrieben Sie:

> I get it: Bugzilla is not designed to look retrospectively at its DB.

But you have considered old charts? Because those optionally create
historical data, if their queries are enough for you.

> --regenerate

https://www.bugzilla.org/docs/5.0/en/html/integrating/api/collectstats.html

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Gesch=E4ftsf=FChrer: Andreas Muchow

0
windows
4/25/2017 11:24:46 AM
Again thank you for the answers.

I can only apologise again, probably the context in which I operate makes m=
e ill-equipped for this discussion. I use a variety of tools on a regular b=
asis and the ability of run arbitrary searches is key to how we work.

The idea that someone could come up today with all the questions they will =
need the answer to in one year is just beyond my imagination. I actually sp=
end more than half of my time trying to convince people that that kind of u=
pfront planning it's not going to ever work and I have quite a few scars to=
 prove it. You know, program manager turned Lean coach sort of beast.

So in my very humble opinion the new charts are an expression of wishful th=
inking in a complex context. For simple contexts that change rarely it may =
be different of course.

The old charts are not powerful enough unfortunately. The basic kind of inf=
ormation that most tools allow to extract are flexible Cumulative Flow Diag=
rams. To be flexible they need to be able to track and freely associate dif=
ferent states and categories. Also stats of state transitions over time are=
 key to determine if any experiment or change is succeeding or failing.
Then, intervals: how long between a bug is raised and when it's resolved de=
pending on clusters of resolutions, that kind of stuff. Still, flexible as =
in my context there's a tendency to reorganise periodically backlogs and pr=
oducts. All filtered on multiple fields including custom ones.

All possible with BugzillaMetrics... eh.

Gosh I would completely and utterly hate to move our bug tracking but as it=
 is we can't really run any experiments without being able to check its eff=
ect. Certainly not Jira. Maybe RedMine? I've seen some good plugins.=20

Don't know. I'm a bit down about all this.

Thank you again,
Carlo
0
volpi
4/25/2017 12:01:50 PM
Guten Tag volpi.c@gmail.com,
am Dienstag, 25. April 2017 um 14:01 schrieben Sie:

> Gosh I would completely and utterly hate to move our bug tracking
> but as it is we can't really run any experiments without being able
> to check its effect. Certainly not Jira. Maybe RedMine? I've seen some go=
od plugins.

How about repairing BugzillaMetrics? At least some sources seems to be
available, you might find someone repairing it for you or do it
yourself.

https://sourceforge.net/p/bugzillametrics/code/HEAD/tree/
https://www.bugzilla.org/support/consulting.html

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Gesch=E4ftsf=FChrer: Andreas Muchow

0
windows
4/25/2017 12:57:50 PM
Yes Thorsten, 

I agree I think it's the best thing to try in the short term. It's likely something small this time around and I'd love to contribute back to that project.

I'm worried about a big change of API in the future though.

I'll mention here if we manage to fix it.

Cheers!
Carlo
0
volpi
4/25/2017 4:00:14 PM
On 25/04/17 13:01, volpi.c@gmail.com wrote:
> All possible with BugzillaMetrics... eh.

I've never heard of this tool. Is it open source? Is it possible to
update it to work with new Bugzillas? That might be the best route to
what you want.

Gerv
0
Gervase
4/26/2017 9:03:20 AM
Reply: