672952 - Get email addresses and crash stacks for [@ nsStandardURL::SchemeIs(char const*, int*)]

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[[:Cww]]

I'm sending emails to crashing users with [@ nsStandardURL::SchemeIs(char const*, int*)] signature --- I have a list of crash IDs but there doesn't seem to be a good automated way to get the email addresses out.  There are over 250 reports here and I'd rather not manually go through them all.

I'd like a CSV of email, first module without a "source" in the stack and crashID.  Preferably with duplicate emails removed (although I can do that part myself.)

Comment 1

[Robert Helmer [:rhelmer]]

Attachment: small script to extract email via web service

Here is a little stopgap script which grabs the raw report via HTTPS+authentication for each OOID in STDIN, and returns just the email address.

I'd like to solve this in a simpler/more supportable way, ideally by making the postcrash email system usable for your use case, but this should serve as an example of how to extract this kind of info without having to block on us to run queries against the data storage etc.

This will only work with a Socorro admin account of course. 

However, maybe there is some value in providing a tool like this for extracting data from socorro via the web interface? If we keep it, some ideas for improvement:

* add help output if nothing in stdin
* allow username/password via args, env variables, prompted stdin
* allow JSON field (in this case "Email") to be specified by arg

Comment 2

[Robert Helmer [:rhelmer]]

Attachment: small script to extract email via web service

Comment 3

[[:Cww]]

WFM... this plus a script that takes available dump data and scrapes it to figure out what the malware DLL is... instant win!

Thanks!