Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Deleted Email Messages still appearing in the Social Pane

Posted on by 190

Hi,

We run CRM 2015 on-premise so i often use my IT team to bulk update our CRM through SQL.

We needed to delete about 100,000 email message records from the system as they were cluttering the activity feed in the social pane against our accounts and contacts, so naturally i got those records deleted through SQL instead of bulk deleting them myself.

The issue i have now is all those email messages are still appearing in the activity feed of the related accounts and contacts even though when you click on one the actual email record has been deleted. Im wondering if the information displayed in the activity feed is stored in a different table in our database in which case i need to delete those also? Or hopefully theres another way to get these out of our activity feeds.

Any help is much appreciated,

Cheers

Scott

*This post is locked for comments

  • Verified answer
    PS Profile Picture
    PS 23,577 on at
    RE: Deleted Email Messages still appearing in the Social Pane

    Posts/Activity Feeds are separate entity and would have to be deleted separately.

    You might face challenges now as you have already deleted related emails.

    Anyway, from frontend you can not delete it by bulk delete job as you will not be able to find Posts regarding Emails thats a limitation.

    You will have to use SQL to bulk delete: msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.delete.aspx

    msdn.microsoft.com/.../microsoft.crm.sdk.messages.retrieverecordwallrequest.aspx

    Post.RegardingObjectId

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans