Answered

Bulk delete all attachments across all entities

(0) Share

Report

Posted on by Mustaque_Ehiya

142

Other than Notes entities with a filter of isDocument = True, how to schedule a bulk deletion of all attachment entities?

even after running the jobs, attachments are available in different entities.

Curently executing the below SQL Queries with XRMToolBox SQL4CDS utility.

Delete from attachment
Delete from fileattachment
delete from activitymimeattachment
delete from activityfileattachment
Delete from elasticfileattachment
Delete from msdyn_aibfileattacheddata
Delete from msdyn_kbattachment

Categories:

Governance & administering

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

ChrisPiasecki 6,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Mustaque_Ehiya,

Do you have an example of which table/column you're still seeing attachments?

Those tables you listed are mainly for email for email attachments and then a couple of D365 specific ones such as Knowledge Article.

If you're using a custom image or file column, then you'll need to delete from the specific table column that is file/image enabled.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Mustaque_Ehiya 142 on at

Like (0)

Report
Copy link

Link copied!

Running the below sql query scheduled bulk delete jobs

I don't see this activity "file attachment" as a configurable entity if I had to schedule directly in the bulk delete page. Do we have an option to configure the bulk delete of all attachments across entities in CRM itself?

Was this reply helpful? Yes No
ChrisPiasecki 6,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Mustaque_Ehiya,

Some tables like that one won't be available via Advanced Find or through the UI and need to be interacted with programmatically. Some of the XrmToolBox plugins like you've discovered do this and provide a means to do so.

You could use Power Automate to do the bulk deletion yourself using the BulkDelete action. Here is a guide on how to do so.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No