Log All Syncs by Users

[fishtech]

Hi

For reasons of accountability, Supervisors want to view a table of syncs undertaken by employees.

What is the best way to record a log of each time each user syncs (preferably recording the version of the database they are using) so thit can be presented to Supervisors?

Thanks,

ft.

[nick360Works]

Hi fishtech,

In the MirrorSync table, there are fields called lastSuccessfulTimestamp, databaseVersion, and lastUsername or (get(AccountName)) that you can use to track those metrics. If you create a script that performs the MirrorSync script, and tracks the last values for those fields on a successful sync, you can keep a record of those in a separate table.

[Jesse Barnum]

Following up on Nick's suggestion - Assuming that you're using XML (as opposed to JDBC), the place to do this would be in the didSync method of the customization script.

[fishtech]

So to clarify the process would be...

 

1. Create a new Log Table to track meta data of  the syncs

2. Using the didSync section of the customization script ON EACH SPOKE to script a 'new record' in the Log Table and populate using the meta data fields/values mentioned above.

3. Sync Log Table to the server

 

Do I have this correct? If so the data on the server will always be 1 sync behind, but I guess this is acceptable.

Or is there a way to get the Log data directly into a table on the server?

Thanks,

ft.

Edited September 25, 2019 by fishtech