654866 - an admin should be able to get statistics about contributors and team members

Status: RESOLVED WONTFIX

(Mozilla QA Graveyard :: MozTrap, enhancement)

Description

[Cameron Dawson [:camd]]

track community involvement:
    how many test cases did each person run?  
    Who ran the most test cases?
    who found the most failed tests?
    who commented the most on test cases

Comment 1

[Cameron Dawson [:camd]]

A Pivotal Tracker story has been created for this Bug: http://www.pivotaltracker.com/story/show/13024347

Comment 3

[Liz Henry (:lizzard) (relman/hg->git project)]

Hi Cameron, I'd like to do an even more minimal implemenation of this -- I'd like to be able to see a list of all MozTrap users and either their last login date or date they last did any sort of action in MozTrap.  Is this something where you could talk with me to give me some pointers? I am willing to try to write it but it would probably help to have advice. Thanks!

Comment 4

[Cameron Dawson [:camd]]

Hi Liz-- I would be happy to chat with you about this.  Last login and date joined are in the db, so we could show that easily on the summary line for each user.  Last action may be harder. We don't keep an "action log" per se.  Each table records who modified/created each row and the time.  But, that would be an expensive operation to query each table looking for their last action.  However, perhaps it's do-able to show in the user details.  

We could just decide to query certain tables like cases, suites, runs, results, etc for that user.  it might not be that expensive of a query.

Comment 5

[Liz Henry (:lizzard) (relman/hg->git project)]

Cameron, ok! I am interested in getting something into place so that we can put MozTrap data into Baloo , so maybe last action isn't as important as having something that we define as a "contribution" and a datestamp on it. Probably better to give you a call or chat on IRC about this when I get back from PyCon!

Comment 6

[Cameron Dawson [:camd]]

Hey Liz--  Sounds good.  Yeah, ping me when you get back and we can work something out.

Comment 7

[Cameron Dawson [:camd]]

Hey Liz--  I have just started learning about New Relic.  I think this might be a fantastic solution for this kind of data.  I don't really know HOW to use it, yet, but it looks very promising.  And would likely be an easy win for this type of data.

Comment 8

[Stephen Donner [:stephend] Not actively reading bugmail]

Mass-closing remaining MozTrap bugs as WONTFIX, due to 1) the Mozilla-hosted instance being decommissioned (see https://wiki.mozilla.org/TestEngineering/Testrail), and, for now, 2) the still-up code archived at its GitHub page: https://github.com/mozilla/moztrap (we'll decide what's next for that, in the near future).

See also the history and more-detailed discussion which led us here, at https://groups.google.com/forum/#!topic/mozilla.dev.quality/Sa75hV8Ywvk

(If you'd like, you should be able to filter these notification emails using at least the unique string of "Sa75hV8Ywvk" in the message body.

Thanks!