All of our sales force is using the remote msde version of MS CRM 3 and going
'offline' or 'online' (hate the way MS used those terms, but what can you do).

Recently we have a number of users who either 'forget' to go offline &
online OR they are not entering information at all.

I realize that SQL is just doing things with replication, but the question
keeps coming up --- how do we know that the users are going offline & online
to sync their data? Does anyone know of a way that I can either view a table
with that info or look in the replication system tables for that type of info?

Unfortunatly telling them to 'just do it' is not enough - we need to turn
into IT thugs... ah well...

ideas?

I believe that in the Outlook Client, there is a section where you set how
often it syncronizes with the server, regardless of whether the remote user
goes on or off line. I am under the impression that at all times when they
are on-line... the sycronization occurs. You can also set the syncronization
time for the clients in the system administration area. The same area also
controls the "auto-tagging" features. Hope this helps.

"jymm2000" wrote:

Not the answer I am looking for Bob - If you are a remote user in CRM your
information is stored in an MS local database, not in an ost or pst. Outlook
syncs one way (using Exchange) & CRM syncs another using SQL & the MS
database. The sync works fine - I just want to be able to produce a report
that would say (for example:
User Last CRM Sync to DB
Bob H 11/1/06 06:00:00 am
Jim W 11/22/06 06:33am

(or similar

"Rob Huseman" wrote:

Look at the following tables in the CRM database:

Subscription
SubscriptionClients
SubscriptionSyncInfo
SyncEntry_{Guid}

Maybe you find the information you're looking for.

--
Michael

Web: http://www.stunnware.com/crm2
Feed: http://www.stunnware.com/crm2/atom.aspx

----------------------------------------------------------

"jymm2000" <jymm2000@discussions.microsoft.com> schrieb im Newsbeitrag
news:A82EA2F0-3576-4448-8CF3-84C11F086727@microsoft.com...

BINGO Michael - now the big question - any idea what the 'Subsciption Type'
is??? I see some users with values of 0 or 1 or 2 --- some with multiple...
one value when things were sent 'up' to the server and another when things
were sent 'down' to the client???

"Michael Höhne" wrote:

I haven't investigated the values in detail, so the best you can do is to
save the values in these tables, go offline and see what has changed. Make
some changes in offline mode and go back online. Again watch for changes and
maybe you have the answer to your question.

--
Michael

Web: http://www.stunnware.com/crm2
Feed: http://www.stunnware.com/crm2/atom.aspx

----------------------------------------------------------

"jymm2000" <jymm2000@discussions.microsoft.com> schrieb im Newsbeitrag
news5D5CC8F-ADE8-4288-873C-74C3D61AF59C@microsoft.com...