How to get which user has mobile sync activated: Difference between revisions
No edit summary |
No edit summary |
||
(10 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
== | {{BC|Certified}} | ||
__FORCETOC__ | |||
<div class="col-md-12 ibox-content"> | |||
=How to get which user has mobile sync activated?= | |||
<hr> | |||
{{KB|{{ZC}}|{{ZCS 9.0}}|{{ZCS 8.8}}|{{ZCS 8.7}}|}} | |||
<hr> | |||
<h2>Problem:</h2> | |||
How to get which user has mobile sync activated? | |||
<h2>Solution:</h2> | <h2>Solution:</h2> | ||
To get a list of users which have mobile sync activated run the below command | To get a list of users which have mobile sync activated run the below command. | ||
mysql -e 'select mb.comment, md.mailbox_id, md.device_id, md.device_type, md.model, md.os from zimbra.mobile_devices md INNER JOIN zimbra.mailbox mb ON md.mailbox_id = mb.id ;' | mysql -e 'select mb.comment, md.mailbox_id, md.device_id, md.device_type, md.model, md.os from zimbra.mobile_devices md INNER JOIN zimbra.mailbox mb ON md.mailbox_id = mb.id ;' | ||
{| class="wikitable" style="background-color:#d0f0c0;" cellpadding="10" | |||
|'''Submitted by''': Prabhat Kumar | |||
|} | |||
{{Article Footer|ZCS 9.0, 8.8, 8.7,|2017-08-23}} | |||
Latest revision as of 20:29, 4 May 2023
How to get which user has mobile sync activated?
Problem:
How to get which user has mobile sync activated?
Solution:
To get a list of users which have mobile sync activated run the below command.
mysql -e 'select mb.comment, md.mailbox_id, md.device_id, md.device_type, md.model, md.os from zimbra.mobile_devices md INNER JOIN zimbra.mailbox mb ON md.mailbox_id = mb.id ;'
Submitted by: Prabhat Kumar |