search

evristzam / ndt

Automatically exported from code.google.com/p/ndt
Other
0 stars 0 forks source link

Client meta file fields garbled #58

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
The problem was noticed by Tiziana Refice at Google when summarizing the 
distinct values for client_os field and the client_browser fields. The values 
she found don't make sense, looking like maybe the client code responsible for 
parsing them out of the user agent string has a bug.

The tables below, from her findings, including the distinct values for the 
respective fields and the count of each from the data collected August 2011.

Values for the client_os field:

| Linux                              |                              176 |
| net                                |                             6915 |
| d                                  |                                4 |
| et                                 |                              124 |
| tbusiness.net                      |                                2 |
| k                                  |                               10 |
| iamedia.cz--kontakty.viamedia.info |                               16 |
| liant.net                          |                                2 |
| ddr.arpa                           |                                2 |
| t.net                              |                               10 |
| SunOS                              |                                2 |
| 9.in-addr.arpa                     |                                2 |
| a                                  |                                4 |
| t                                  |                                2 |
| pa                                 |                                2 |
+------------------------------------+----------------------------------+

Values for the client_browser field:

| fo                             |                                    16 |

Original issue reported on code.google.com by cmdln....@gmail.com on 15 Sep 2011 at 8:03

GoogleCodeExporter commented 9 years ago 
Tiziana, is this ticket still valid?

Original comment by jslawin...@soldevelo.com on 15 Apr 2014 at 7:23

GoogleCodeExporter commented 9 years ago 
The results for the first quarter of 2014 are
Row connection_spec_client_os   count    
1   Windows 29552877040  
2       24081657251  
3   Linux   66508123     
4   qnx 40946    
5   9.in-addr.arpa  3947     

FYI: The BigQuery query run to get the results above is

SELECT
  connection_spec.client_os, count(*) as count
FROM
  m_lab.2014_01,m_lab.2014_02,m_lab.2014_03
GROUP BY
  connection_spec.client_os;

Original comment by tizi...@google.com on 15 Apr 2014 at 8:03

GoogleCodeExporter commented 9 years ago

Original comment by jslawin...@soldevelo.com on 25 Jun 2014 at 8:18