To generate an output using SQL showing mailbox synchronization statistics please see the following KB article. https://support.quest.com/migration-manager-for-exchange/kb/213196/how-to-export-a-report-on-mailbox-switch-status-for-mage-based-collections
The above method of querying SQL for synchronization statistics was more relevant in QMM 8.13 and earlier versions. In a late hotfix release for 8.13 there were Powershell cmdlets added to the MMEX Powershell module which will enable you to generate a report on this information via Powershell.
To obtain synchronization statistics of a collection of mailboxes from a collection, use the Get-MMExCollectionStatistics and Get-MMExMailboxStatistics cmdlets, respectively. They have the following syntax:
Get-MMExCollectionStatistics -Type Calendar -Name "Collection1"
Get-MMExMailboxStatistics -Name "Collection2" -Type Mail
Where
Type can be Mail for a mailbox collection or Calendar for a calendar collection
Results can be either viewed in a new console window or exported to a CSV file.
For more details, see help for the cmdlets in Windows PowerShell.
Example
The following command gets statistics of "Collection1" and "Collection2" and then writes the output to the specified CSV file. It uses the Type parameter to specify the job type; the Name parameter is passed from pipeline.
PS C:\>@("Collection1", "Collection2") | Get-MMExCollectionStatistics -Type Mail | Export-Csv -NoTypeInformation -Encoding UTF8 -Path "C:\MMEX\export.csv"
Results in the CSV file will look as follows:
"CollectionName","CollectionId","New","InProgress","ReadyToSwitch","Switched","Completed","Failed","Total"
"Collection1","3","20","55","3","2","20","0","100"
"Collection2","9","100","0","0","0","0","0","100"
For more information on using the MMEX Powershell module and its cmdlets see the following section of the User Guide: https://support.quest.com/technical-documents/migration-manager-for-exchange/8.14/user-guide/22#TOPIC-711685
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center