1

Issue
-------------
Count of records associated to marketing list and displayed by 'Members Count' are incorrect in CRM 2013
Marketing List has 100 members added but in the 'Member Count' Field that display <> 100
Creating new Marketing List with same records resolved the issue.
SQL Query that pull 'Member Count' (as per current design)
---------------------------------------------------------------------
Select MemberCount From ListBase Where ListName = '<Marketing_List_Name>'

SQL Query that will pull correct 'Member Count' (need to be updated)
-------------------------------------------------------------------------------
Select Count(CB.FullName ) From ContactBase CB, ListBase LB, ListMemberBase LMB
Where CB.ContactId =LMB.EntityId and LB.ListId = LMB.ListId and LB.ListName = '<Marketing_List_Name>'

Category: General
STATUS DETAILS
Completed
Ideas Administrator

 Thank you for reaching out.

Your suggestion seems to be a product bug. We had provided a bug fix in that area.

Please reach out to the relevant support channels as specified in Product support (http://go.microsoft.com/fwlink/?LinkID=616937).

Sincerely,

PM,

Microsoft.