437092 - query for tablet pc related crashes in socorro db

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[(not currently active) Ted Mielczarek]

I'd like to get a sense of how many crashes are happening to Tablet PC users, related to bug 432467. Aravind, can you run this query on the production db for me?

select count(reports.signature), reports.signature from reports LEFT JOIN MODULES on reports.id = modules.report_id WHERE reports.date > now() - interval '2 weeks' AND modules.filename = 'tiptsf.dll' group by reports.signature order by count(reports.signature) desc;

The results should be anonymous, so you can just attach it here.

Comment 1

[(not currently active) Ted Mielczarek]

Oh, and if that query doesn't take forever, maybe we can run this one too:

select count(reports.signature), count(distinct user_id) as users, reports.signature from reports LEFT JOIN MODULES on reports.id = modules.report_id WHERE reports.date > now() - interval '2 weeks' AND modules.filename = 'tiptsf.dll' group by reports.signature order by count(reports.signature) desc;

Comment 2

[chizu]

Attachment: Query results

Comment 3

[chizu]

result.out is the summary query, result2.out is the comment #1 query.