How to get which user has mobile sync activated

1. Zimbra Tech Center
2. Certified
3. How to get which user has mobile sync activated

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