655750 - Add release channel to daily CSV

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[Robert Kaiser]

For running custom reports from CSVs, it would be interesting to have the release channel and duplicate fields available in those CSVs.

Comment 1

[K Lars Lohn [:lars] [:klohn]]

splitting into two separate bugs.  This one is for ReleaseChannel only...

Comment 2

[Robert Kaiser]

Laura, can we get that targeted for a release? It currently makes it impossible to get some data that we'd love to have.

Comment 3

[Laura Thomson :laura]

This is a one line change apparently, and would be nice to have for 2.2.

Comment 4

[Laura Thomson :laura]

This should have been in 2.2.2.  Ship it next week instead.

Comment 5

[Robert Helmer [:rhelmer]]

Attachment: add release channel to csv

Now that 2.2 is live, I think we can just expose this new column

Seems to do the right thing against stagedb, what do you think brandon?

Comment 6

[Robert Helmer [:rhelmer]]

Trunk:
Updated to revision 3480.

Branch:
Committed revision 3481.

Comment 7

[Robert Helmer [:rhelmer]]

Generated a CSV on stage for verification purposes:

http://people.mozilla.org/~rhelmer/temp/20110825-pub-crashdata.csv.gz

$ gzip -dc 20110825-pub-crashdata.csv.gz | head -2
signature	URL (removed)	uuid_url	client_crash_date	date_processed	last_crash	product	version	build	branch	os_name	os_version	cpu_info	address	bug_list	user_comments	uptime_seconds		adu_count	topmost_filenames	addons_checked	flash_version	hangid	reason	process_type	app_notes	install_age	duplicate_of	release_channel
hang | _SEH_epilog4	URL (removed)	http://crash-stats.mozilla.com/report/index/e42e1897-5830-4730-81d0-83ed42110825	201108242240	201108250000	\N	Firefox	5.0	20110427143820	2.2	Windows NT	6.1.7600	x86 | GenuineIntel family 6 model 23 stepping 10 | 2	0x77b6f861		\N	4560		\N	F2080425331____________________________________________________	checked	10.1.102.64	fa8a7611-f899-45ce-aa18-2c5fd3e1f53a	EXCEPTION_BREAKPOINT	plugin	AdapterVendorID: 8086, AdapterDeviceID: 2a42, AdapterDriverVersion: 8.15.10.1749 | D3D10 Layers? D3D10 Layers- | D3D9 Layers? D3D9 Layers-	177869	\N	beta

Comment 8

[Robert Helmer [:rhelmer]]

There's also a private CSV (contains unredacted email/URL), here's just the header (can take my work for it that the data is there :P):

$ gzip -dc 20110825-crashdata.csv.gz | head -1
signature	url	uuid_url	client_crash_date	date_processed	last_crash	product	version	build	branch	os_name	os_version	cpu_infaddress	bug_list	user_comments	uptime_seconds	email	adu_count	topmost_filenames	addons_checked	flash_version	hangid	reason	process_type	app_notes	install_age	duplicate_of	release_channel

Comment 9

[Robert Kaiser]

Looks good to me from comment #7 and #8.

Comment 10

[Matt Brandt [:mbrandt]]

Thanks rhelmer for helping divine this into the bug. Bumping to QA verified per comment 7 and comment 8.