The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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 !

asked 07 Aug '14, 05:37

vdcey's gravatar image

vdcey
619212735
accept rate: 33%

1

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.

(07 Aug '14, 09:57) Chris Keating

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.

permanent link

answered 08 Aug '14, 04:53

Mike%20Killey's gravatar image

Mike Killey
291169
accept rate: 60%

1

thanks, doing that .

(15 Sep '14, 05:18) vdcey

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

permanent link

answered 07 Aug '14, 13:07

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×266

question asked: 07 Aug '14, 05:37

question was seen: 308 times

last updated: 15 Sep '14, 05:18