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: Raunaq Malik