Difference between revisions of "How to get which user has mobile sync activated"

(Created page with "=== <h1>How to get which user has mobile sync activated</h1> === <h2>Solution:</h2> To get a list of users which have mobile sync activated run the below command <pre>mysq...")
 
Line 6: Line 6:
 
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
  
<pre>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 ;'</pre>
+
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:  Heera Singh Koranga

Revision as of 09:18, 21 August 2017

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: Heera Singh Koranga

Jump to: navigation, search