Is it a way to identify the users who added members in a static marketing list ?
I would like to have a view of all contacts that are members of a marketing list with the contact name, its company and the user who added the member.
The advanced find does not give me access to the List Member entity.
Therefore, I built a FetchXML based on following entities:
<fetch count="50">
<entity name="list">
<attribute name="listname" />
<filter>
<condition attribute="listname" operator="begins-with" value="SQ" />
</filter>
<link-entity name="listmember" from="listid" to="listid" alias="lm" intersect="true">
<link-entity name="systemuser" from="systemuserid" to="createdby" alias="su">
<attribute name="fullname" />
</link-entity>
<link-entity name="contact" from="contactid" to="entityid" alias="c" intersect="true">
<attribute name="fullname" />
<link-entity name="account" from="accountid" to="parentcustomerid" alias="a">
<attribute name="name" />
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>
The results are good.
Unfortunately, when I try to publish this view using the XrmTools View Designer, I can only see ONE record.
Hi Amit,
Thanks a lot for your useful and swift feedback.
The Audit log is only providing detailed and punctual information.
My objective is to get information about the participation of users (how many contacts have been added to a static marketing list by different users)
I finally found a solution with PowerBI using the Memberlist entity (M-M)
This way, for each static marketing list, I can see how many members have been added by each user.
Kind Regards,
Hello User,
Please enable auditing for the Marketing list. and it will show the operations performed on the marketing list.
community.dynamics.com/.../date-a-contact-or-account-was-added-to-the-marketing-list
learn.microsoft.com/.../audit-data-user-activity
Thank you,
Amit Katariya
Hi PParys,
There are no attributes of the marketing list membership stored, it is a direct many-to-many relationship between the list and the list member.
So, you can use CRM auditing feature to check who added members in a static marketing list.
--Navigate to Settings > Global Auditing Settings, click on "Start Auditing" click OK.
-- Settings -> Auditing window, click on Entity and Field Audit Settings, find Marketing List and click on "Auditing" check box
Test:
--Add some contacts to a Marketing List. then go back to Settings -> Auditing > Audit Summary View:
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156