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.

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.

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.

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, 20196 yr by fishtech