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

* Your Email Address
* Spam protection	Enter the letters below: . .. .. .. .._. \| \|\|__\|\| \|\| \| \| \|/\\|\| \|\|__\|\|/\\|_\|_
Comment	>> 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) >
Attachment
Watch this ticket

Saved Queries