[Tickets #14655] Re: OS version detection when using android/gmail app doesn't work

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14655
------------------------------------------------------------------------------
  Ticket             | 14655
  Updated By         | manuel-horde at mausz.at
  Summary            | OS version detection when using android/gmail app
                     | doesn't work
  Queue              | Synchronization
  Version            | FRAMEWORK_5_2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


manuel-horde at mausz.at (2017-06-11 14:43) wrote:

> From this data I can tell that no Android 7 devices has an OS  
> property. Same for all android devices with "Android-Mail" being the  
> device_agent.

Some quick stats:

mysql> select count(*) from horde_activesync_device where device_type  
like 'Android' \G
count(*): 74

mysql> select count(*) from horde_activesync_device where device_type  
like 'Android' and device_properties like '%"Settings:OS"%'\G
count(*): 52

mysql> select count(*) from horde_activesync_device where device_agent  
like 'Android-Mail/%'\G
count(*): 12

mysql> select count(*) from horde_activesync_device where device_agent  
like 'Android-Mail/%' and device_properties like '%"Settings:OS"%'\G
count(*): 0

mysql> select distinct device_agent, device_properties like  
'%"Settings:OS%' AS hasOS from horde_activesync_device where  
device_type like 'Android' order by device_agent;
+----------------------------------------------------------------+-------+
| device_agent                                                   | hasOS |
+----------------------------------------------------------------+-------+
| AirWatch Boxer (SM-G900F; Android 6.0.1) Version 3.10.1.13/337 |     0 |
| Android-Mail/6.10.23.137993986.release                         |     0 |
| Android-Mail/6.10.9.136347105.release                          |     0 |
| Android-Mail/6.5-1.123769152.release                           |     0 |
| Android-Mail/6.9.133109232.release                             |     0 |
| Android-Mail/6.9.25.134833125.release                          |     0 |
| Android-Mail/7.2.12.147797444.release                          |     0 |
| Android-Mail/7.2.26.149804060.release                          |     0 |
| Android-Mail/7.3.26.153522445.release                          |     0 |
| Android-Mail/7.4.23.154506495.release                          |     0 |
| Android-Mail/7.5.21.158049789.release                          |     0 |
| Android-Mail/7.5.7.156101332.release                           |     0 |
| Android/4.0.3-EAS-1.3                                          |     0 |
| Android/4.0.3-EAS-1.3                                          |     1 |
| Android/4.0.4-EAS-1.3                                          |     1 |
| Android/4.1.1-EAS-1.3                                          |     1 |
| Android/4.1.2-EAS-1.3                                          |     1 |
| Android/4.2.1-EAS-1.3                                          |     1 |
| Android/4.2.2-EAS-1.3                                          |     0 |
| Android/4.2.2-EAS-1.3                                          |     1 |
| Android/4.4-EAS-1.3                                            |     1 |
| Android/4.4.2-EAS-1.3                                          |     0 |
| Android/4.4.2-EAS-1.3                                          |     1 |
| Android/4.4.4-EAS-2.0                                          |     0 |
| Android/4.4.4-EAS-2.0                                          |     1 |
| Android/5.0-EAS-2.0                                            |     0 |
| Android/5.0-EAS-2.0                                            |     1 |
| Android/5.0.2-EAS-2.0                                          |     1 |
| Android/5.1-EAS-2.0                                            |     1 |
| Android/5.1.1-EAS-1.3                                          |     1 |
| Android/5.1.1-EAS-2.0                                          |     1 |
| Android/6.0-EAS-2.0                                            |     1 |
| Android/6.0.1-EAS-2.0                                          |     1 |
| Android/7.0-EAS-2.0                                            |     1 |
| Nine-C6603/10.6.A.0.454                                        |     1 |
| Nine-occam/LMY47V                                              |     1 |
| samsungGTI9300/6.0.1-EAS-2.0                                   |     1 |
| Tasks+Notes/8.2.1                                              |     1 |
+----------------------------------------------------------------+-------+
38 rows in set (0.00 sec)