locked
Where is the user number in the email tracking token stored? RRS feed

  • Question

  • Hi, all!

    I have a project for a contact center. One of the requirements is that incoming email messages should be dispatched through another system before delivered to the users. The contact center uses a single email address for all external dialogue, and the dispatch solution works as a proxy between that address and all the users

    This works quite all right in conjunction with MS CRM. Incoming emails are promoted to CRM whenever they are dispatched to a user, and outgoing emails are automatically tracked.

    However, incoming emails sent in reply to an outgoing email should be dispatched to the user who sent the email in the first place, not some random user first availble.

    I can of course run a query and get the outgoing email from CRM matching the tracking token in the subject line, but I am looking for a more foolproof solution.

    The Tracking Token consists of an organisation prefix, a base number, a four digit numeric user id and a 7 digit running counter

    Now, my question is: Where is the numeric user id stored? I can't find it in the systemuser entity, (or hidden in the table), and it is not present on the mailbox entity either. Where are these numbers stored? Are the generated based on some other value? Does anyone know how?

    Tuesday, October 27, 2015 12:38 PM

Answers

  • It's stored in the trackingtokenid attribute of usersettings. The systemuserid is the primary key of this entity

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by Torstein Utne Tuesday, October 27, 2015 2:26 PM
    Tuesday, October 27, 2015 2:19 PM
    Moderator

All replies

  • It's stored in the trackingtokenid attribute of usersettings. The systemuserid is the primary key of this entity

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by Torstein Utne Tuesday, October 27, 2015 2:26 PM
    Tuesday, October 27, 2015 2:19 PM
    Moderator
  • I verified that I indeed can get that info by querying that entity. Now I'll be able to build a more robust service.

    Thanks a lot!
    Tuesday, October 27, 2015 2:28 PM