So I can use the advanced find to find thousands of emails with large file attachments, but there appears to be no way to bulk delete just those attachments without deleting the emails themselves.
Is this correct?
Anyone know of a way to set the default so that email attachments will not be stored in CRM?
*This post is locked for comments
Hey Shahzeb, what is the size of attachments that are larger then for this script? ConditionOperator.GreaterEqual, 100000));
am i correct that this is greater then 100mb? Also will this script work in a crm 4.0 environment? Thanks!!!
just use this code and you have no need to delete emails, it will delete all the attachments greater than mentioned size in below code
IOrganizationService Service = GetCrmService();
QueryExpression queryAtt = new QueryExpression("activitymimeattachment");
queryAtt.ColumnSet = new ColumnSet(new string[] { "activityid", "attachmentid","filesize" });
queryAtt.Criteria.AddCondition(new ConditionExpression("filesize", ConditionOperator.GreaterEqual, 100000));
EntityCollection eatt = Service.RetrieveMultiple(queryAtt);
foreach (Entity item in eatt.Entities)
{
Service.Delete(item.LogicalName,item.Id);
}
Reference this doc:
community.dynamics.com/.../deleting-email-attachments-in-dynamics-crm-2016
Hi Dan,
Please refer to the link below for more information.
community.dynamics.com/.../216624.aspx
Thank You !
The emails would need to be reset to draft status first before you can delete the attachments and that can be done through a workflow or via the SDK. Setting the emails back to draft status would allow for a bulk deletion of email attachments.
Follow the links mentioned below please:
mscrmtools.blogspot.com/.../new-tool-bulk-delete-launcher.html
social.microsoft.com/.../fe1ec159-f079-43e7-9f13-dc55f13751d4
#1
André Arnaud de Cal...
291,820
Super User 2024 Season 2
#2
Martin Dráb
230,514
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
