Is there a way to see all synchronization dates for a Mobilink User ?

[Former Member]

Is there a way to see this in the consolidated database? I think I can see the last download time in the Subscription table but I need to check if someone had a synchronization on a certain date last week.

Thanks for the tips !

[chris_keating]

A ML server running with minimum logging verbosity (-v) would record each sync request as shown in the following example:

I. 2014-08-07 09:36:52. <1> Request from "UL 16.0.1915" for: remote ID: dd06c479-38d6-4ea8-87d4-158a39767ca7, user name: 50, version: custdb 16.0

Other than that, nothing is built into MobiLink system tables to record each synchronization request.

[Former Member · Accepted solution]

It's a bit late now to see if a sync occured last week. But for future use you might want to look at using the Mobilink connection scripts to record each sync within the consolidated database. I use the begin_synchronization and end_synchronization scripts to record the last time that a remote database has synced within our SQL Server 2012 db.

[Former Member · Accepted solution]

thanks, doing that .

[Breck_Carter]

If it's a SQL Anywhere consolidated database, consider using dbtran to query the transaction log.