826564 - add new 'exploitability' column to 'reports' in the Socorro UI

Status: RESOLVED FIXED

(Socorro :: Webapp, task)

Description

[Gary Kwong [:gkw] [:nth10sd] (NOT official MoCo now)]

+++ This bug was initially created as a clone of Bug #807349 +++

The database column for 'exploitability' was added to 'reports' in bug 807349, so it'll be nice to be able to sort or filter by exploitability when logged in to the Socorro web UI.

Comment 1

[Laura Thomson :laura]

You mean add it as a column to reports/list on the Reports tab?

Comment 2

[Gary Kwong [:gkw] [:nth10sd] (NOT official MoCo now)]

I mean as one more column in this page:

https://crash-stats.mozilla.com/report/list?range_value=7&range_unit=days&date=2013-01-03&signature=js%3A%3ACompartmentChecker%3A%3Afail%28JSCompartment*%2C%20JSCompartment*%29&version=Firefox%3A20.0a1

I now see Date, Dupe, Product, Version, Build, OS, Build Arch, Reason, Address, Crash Type, Uptime, Install time, Comments.

While we're at it, adding the URL column might be useful too, but I don't know how practical it will be.

Comment 3

[Robert Kaiser]

I'm not keen on adding new columns there at this time, I know a dozen columns I'd like to have there, but the UI already looks too dense for my taste.

Comment 4

[Gary Kwong [:gkw] [:nth10sd] (NOT official MoCo now)]

We should have a way to quickly glance at topcrashes and in particular look at the exploitable ones. I was thinking that adding a column would serve this purpose.

How about adding a search field in advanced search instead, to search for exploitable crashes?

Comment 5

[Robert Kaiser]

(In reply to Gary Kwong [:gkw] from comment #4)
> How about adding a search field in advanced search instead, to search for
> exploitable crashes?

Sure, once we get the search mechanism we were promised to get a year ago. You know, getting features into Socorro seems to always take between half a year and forever.

Comment 6

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/229eb561c36bbe0dd20faaf4190d7d5e8ea63af6
bug 826564 Add exploitability to reports_clean

https://github.com/mozilla/socorro/commit/d1dd6dfb633f7887d0ea79dde576e76be89f7668
Merge pull request #1277 from selenamarie/bug826564-exploitability-sql

bug 826564 Add exploitability to reports_clean

Comment 7

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/f1681680080ac1ac52f708bfaec01d33a9c2896b
bug 826564 Add signature to exploitability report

https://github.com/mozilla/socorro/commit/22c33b0e84f504c272bce1270ebee3d650d19504
Merge pull request #1281 from selenamarie/bug826564-add-signature-column

bug 826564 Add signature to exploitability report

Comment 8

[Selena Deckelmann :selenamarie :selena]

Applied to prod.