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
654222839
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
25.8k428592853
accept rate: 20%

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:

×295

question asked: 07 Aug '14, 05:37

question was seen: 331 times

last updated: 15 Sep '14, 05:18