1

Where is the following EXM information stored in Sitecore database (version 9.2).

  1. Subscribe list
  2. Unsubscribe list

I have checked in the Sitecore92_EXM.Masterdatabase. But I was unable to find it. Please give some suggestion.

4

The list of subscribed users is not stored on EXM.Master database .

The users/contacts subscribtion is stored in xdb database, in the shards databases.

To be more specific, this information is stored in ContactFacets table on ListSubscribtion facet

enter image description here

This is not very well documented but you can find some information here:

https://doc.sitecore.com/developers/92/sitecore-experience-platform/en/use-core-collection-model-facets.html#listsubscriptions-listsubscriptions

5
  • Thank you Vlad lobagiu. – tamizhendhi v Feb 14 '20 at 9:02
  • if it helps you please mark the answer as correct. – Vlad Iobagiu Feb 14 '20 at 9:05
  • I need another one info. How do get the subscribe and unsubscribe list in code(using query or something). could you suggest.thanks – tamizhendhi v Feb 14 '20 at 9:06
  • sitecore.stackexchange.com/questions/10677/… here is the answer for your 2nd question – Vlad Iobagiu Feb 14 '20 at 9:14
  • Hi Vlad lobagiu, Do we get contact list based on the user?. EX. one user associated with multiple contact list. Is there any way to find users details in sitecore database. Thanks.. – tamizhendhi v Mar 4 '20 at 9:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.