How to confirm how many items have been collected by ZyLAB Exchange Synchronization

SYMPTOMS

This article describes how to confirm how many items have been collected from Journal mailbox(s) by the ZyLAB Exchange Synchronization service.

CAUSE

Not applicable.

RESOLUTION

The number of items collected in a single Journal Synchronization stage can be confirmed by looking at the log.

The ZyLAB.EDiscovery.Exchange.Standalone.WinService.exe.log file will have occurrences of the following line for each Journal mailbox processed by ZyLAB Exchange Synchronization.
Synchronization from journal <JOURNAL_MAILBOX> is complete. Summary: Successfully processed <NUMBER_of_COLLECTED_ITEMS>, Errors <NUMBER_of_ERRORS>

The number of items that were collected since the journal mailbox was being processed by ZyLAB Exchange Synchronization, can be confirmed in Legal Review. Alternatively a simple SQL query on the ZyLAB Exchange Synchronization database will display the same number.

USE ZyLABexchange
SELECT COUNT as CollectedItems FROM UnwrappedJournalItem uji
INNER JOIN UserItemStateInMailbox uis ON uji.Id = uis.UJI_Id

APPLIES TO

3.7; 3.7 Service Pack 1