Description of problem: I would like to see a report by machine. How many times a machine is set to Broken by the scheduler. Also how many times a user clicks "Report a problem" per machine.
*** Bug 752109 has been marked as a duplicate of this bug. ***
Additional info: A report that contains frequently broken systems would be very useful. I'm not certain what the best metrics to use for generating such a report would be - but something like "disabled X times in Y time period" would fit the bill nicely. Ideally, we'd be able to define X and Y before running the report, or leave those values set in a config file somewhere that could be tweaked without needing any package updates.
Systems against which a problem was reported can be found using: mysql> select system.fqdn,activity.created from system, system_activity, activity where system.id = system_activity.system_id and system_activity.id=activity.id and activity.action='Reported problem' System status can be obtained using: mysql> select * from system_status_duration order by system_id; This gives us the status of a machine and the time period during which it remained in that status. We can use these details to obtain the information sought as part of this bug.
Admin guide updated to include the above information: http://gerrit.beaker-project.org/#/c/1546/
Re-opening this so it doesn't get lost...
http://gerrit.beaker-project.org/1580
http://gerrit.beaker-project.org/1608
Beaker 0.11.0 has been released.