Closed Bug 1431198 Opened 2 years ago Closed 2 years ago

Add telemetry environment's new security software fields

Categories

(Data Platform and Tools :: Datasets: Main Summary, enhancement, P1)

enhancement
Points:
1

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: aklotz, Assigned: amiyaguchi)

References

Details

Attachments

(2 files)

In bug 1418131 I added fields for security software registered on Windows machines. I'd like to be able to surface those in redash et al

Note that these fields are only present when the submitter's OS is Windows 8 or newer.

Rather than repeating the same information here, the "antivirus" "antispyware" and "firewall" fields are documented in toolkit/components/telemetry/docs/data/environment.rst
Hey Aaron,

Is this data included with the main ping? If so, where? Do you usually query from main_summary or the longitudinal dataset?

Thanks!
Flags: needinfo?(aklotz)
It is included in the environment block, which as I understand is part of the common ping format.

I'm not quite sure, but based on the docs I think we want to query this from the longitudinal dataset.
Flags: needinfo?(aklotz)
Moving to the longitudinal component. Frank - can you comment?
Component: Datasets: General → Datasets: Longitudinal
Flags: needinfo?(fbertsch)
My recommendation would be to add this instead to main_summary. We're trying to make the absolute minimum changes to longitudinal as possible. Aaron, would that be sufficient for you?
Flags: needinfo?(fbertsch) → needinfo?(aklotz)
Sure, let's try it.
Flags: needinfo?(aklotz)
Component: Datasets: Longitudinal → Datasets: Main Summary
Summary: Add telemetry environment's new security software fields to redash, sql.tmo, etc → Add telemetry environment's new security software fields
Points: --- → 1
Priority: -- → P2
Assignee: nobody → amiyaguchi
Priority: P2 → P1
This field should appear starting 20180209. During the next backfill, this field will be included.
Status: NEW → RESOLVED
Closed: 2 years ago
Resolution: --- → FIXED
Here's a sample query for validating the data coming in. https://sql.telemetry.mozilla.org/queries/51111/source
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.