How to get which user has mobile sync activated: Difference between revisions
No edit summary |
No edit summary |
||
(5 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
<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}} | |||
Revision as of 19:08, 9 December 2021
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 |