NUMBER_OF_PROFILES (Number of named browser profiles for the current user, as reported by the profile service at startup) is disabled since 69 and it would be a useful probe to use in order to track multi profile generating installations so that such installations could be ignored from retention analysis.

As part of this request I would like to check if there are issues with the probe.
https://sql.telemetry.mozilla.org/queries/69109/source#174376 shows the following weird things:

• Installations with 'null' number of profiles - about a third of all reports
• Installations with 1 profile - about 2 thirds of all reports (makes sense)
• Installations with 2 profiles - only 1
• Nothing else

Could there be an issue with the probe? I'd expect at least a share of installs to have more than 1 profile.
See also https://bugzilla.mozilla.org/show_bug.cgi?id=1296606#c27 that looked at why 11% of installs had 0 profiles

I think there may be an error in that query. I'm not sure what type histogram_parent_number_of_profiles is, but it should be a STRUCT, so the GROUP BY should fail. Here's a query using telemetry.main instead of main_summary which looks at the sum of the histogram:

https://sql.telemetry.mozilla.org/queries/69110/source#174377

The values are about what I'd expect given that most users reporting on March 3 are going to be running versions of Firefox >= 70... except for those reporting 0, those cheeky chums.

The priority flag is not set for this bug.
:mossop, could you have a look please?

For more information, please visit auto_nag documentation.

Romain, do you still want this?

Thanks for the pointer, here is the short form filled in and sorry for the delay!

Apologies for the delay, a lot going on...
Regarding the request, thanks for the pointer, I attach the response.

(In reply to Chris H-C :chutten from comment #3)

I think there may be an error in that query. I'm not sure what type histogram_parent_number_of_profiles is, but it should be a STRUCT, so the GROUP BY should fail. Here's a query using telemetry.main instead of main_summary which looks at the sum of the histogram:

https://sql.telemetry.mozilla.org/queries/69110/source#174377

The values are about what I'd expect given that most users reporting on March 3 are going to be running versions of Firefox >= 70... except for those reporting 0, those cheeky chums.

Though most pings on that query report a null value (2,856,984 of them)?

(In reply to Dave Townsend [:mossop] (he/him) from comment #6)

Romain, do you still want this?

Sorry for the delay Dave, lots going on.
Yes I still want this, let's seefirst if there is an issue with the probe (Comment 8 shows most values are null unless I am misunderstanding the query)

The priority flag is not set for this bug.
:mossop, could you have a look please?

For more information, please visit auto_nag documentation.

(In reply to Romain Testard [:RT] from comment #8)

Apologies for the delay, a lot going on...
Regarding the request, thanks for the pointer, I attach the response.

(In reply to Chris H-C :chutten from comment #3)

I think there may be an error in that query. I'm not sure what type histogram_parent_number_of_profiles is, but it should be a STRUCT, so the GROUP BY should fail. Here's a query using telemetry.main instead of main_summary which looks at the sum of the histogram:

https://sql.telemetry.mozilla.org/queries/69110/source#174377

The values are about what I'd expect given that most users reporting on March 3 are going to be running versions of Firefox >= 70... except for those reporting 0, those cheeky chums.

Though most pings on that query report a null value (2,856,984 of them)?

Yes, that's because most pings cover timespans that don't include startup. Startup's the time that the value is recorded, so the first ping after startup will contain that value. All subsequent pings until the next startup will have no value.

Taking to update schema in tree.

The priority flag is not set for this bug.
:mossop, could you have a look please?

For more information, please visit auto_nag documentation.

https://hg.mozilla.org/mozilla-central/rev/c2d292ae8944