Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
What is the name of table in database of crm 4.0( sql server 2005 ) where I can see all user Synchronizations RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Does anyone know where I could find data about all synchronizations between crm outlook users and sql server 2005?
    What is the name of table ( dbo.??????) in database?
    I'd like to make daily reports about all user syncronizations but can't find this table in database?!
    Please help me!!!
    • Edited by BirgemBorg Friday, August 28, 2009 10:32 PM
    Friday, August 28, 2009 9:57 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Information about synchronizations is dispersed over several tables in the <orgname>_MSCRM database: in the Subscription table you have info about each user and each subscription type (outlook - offline / online), in the SubscriptionSyncInfo you have some more info about each synchronization, and in SubscriptionStatistics_GUID and SyncEntry_GUID contain information about type of objects synchronized, the versions of objects and the sync state.

    I hope that helps,
    Kuba Skalbania
    -- Kuba Skałbania, Netwise
    Saturday, August 29, 2009 2:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    This should become a new post. But I will answer it for you here :). So, in order to find the text values apart from int values for the picklists, you have to query Filtered Views, not tables. So, if your Visit entity is a custom one, you should query "FilteredNew_Visit" view in order to see the values. If your Visit entity is a system entity, but has been renamed, you should query Filtered<systementityname> view.

    I hope that helps now. If it does, please mark this post as answer.

    Best regards,
    Kuba
    -- Kuba Skałbania, Netwise
    Monday, August 31, 2009 9:23 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Information about synchronizations is dispersed over several tables in the <orgname>_MSCRM database: in the Subscription table you have info about each user and each subscription type (outlook - offline / online), in the SubscriptionSyncInfo you have some more info about each synchronization, and in SubscriptionStatistics_GUID and SyncEntry_GUID contain information about type of objects synchronized, the versions of objects and the sync state.

    I hope that helps,
    Kuba Skalbania
    -- Kuba Skałbania, Netwise
    Saturday, August 29, 2009 2:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks! I am beginner with CRM and couldn't find this answer on internet except from u.
    Saturday, August 29, 2009 12:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I have one question more. Do u know where are loacated value list from attributes? for example: I have entity Visits and there are few attributes with picklist. If I open table visit in database I can see value list ( but only codes like 1, 2 3, ..etc ). I am interesting how to find meanings in order to make join with attribuite from Visits.
    for example my attribute is "purpose of visit " and pick list are:
    1) filed visit
    2) Improve sales
    3) Charg debt


    IN table visit I can see Like I've said only 1, 2 and 3 but can find table which contains "filed visit", "improve sales", "Charg Debt".
    Do u know where I have to look?
    Monday, August 31, 2009 9:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    This should become a new post. But I will answer it for you here :). So, in order to find the text values apart from int values for the picklists, you have to query Filtered Views, not tables. So, if your Visit entity is a custom one, you should query "FilteredNew_Visit" view in order to see the values. If your Visit entity is a system entity, but has been renamed, you should query Filtered<systementityname> view.

    I hope that helps now. If it does, please mark this post as answer.

    Best regards,
    Kuba
    -- Kuba Skałbania, Netwise
    Monday, August 31, 2009 9:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    I have investigate few hours last night and found this table at dbo.stringmap where all list are located with the name of attributes.
    It will help me to make datawarehouse and big cube.


    thank you


    BirgemBorg
    Tuesday, September 1, 2009 9:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Kuba,

     

    It seems like in CRM 4.0, the "SubscriptionSyncInfo" tables contains the background synchroization information as well. Is there any way I can retrieve only the synchronization information which is performed by the user i.e only the synchro info which the user clicked on the "Go Offilene/Online" button?

     

    Any inputs on this will be very helpful.

     

    Thanks,

    Sareesh

    Monday, May 30, 2011 1:03 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    I believe you can determine this by the SubscriptionType column in the Subscription table. Only records with SubscriptionType = 0 should relate to Online/Offline synchronisation. You'll probably need to use a SQL cursor to interate through each record in the Subscription table, and query the corresponding SyncEntry table in turn
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, May 31, 2011 1:31 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks David. This information was very helpful.

    Sareesh

    Wednesday, June 15, 2011 4:16 AM