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!

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.

Moving to the longitudinal component. Frank - can you comment?

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?

Sure, let's try it.

This field should appear starting 20180209. During the next backfill, this field will be included.

Here's a sample query for validating the data coming in. https://sql.telemetry.mozilla.org/queries/51111/source