How can I safely remove duplicate MSG files without deleting important emails?

[Robart]

How can I efficiently identify, compare, and delete duplicate MSG files from my system to maintain a clean, organized, and clutter-free email archive that is suitable for both business and personal use, while ensuring that no original or important messages are accidentally removed in the process?

[Jayesh Raghuvanshi]

@Robart 

Use CQL and REST in Confluence Data Center to find .MSG attachments, verify true duplicates by metadata or file comparison, and delete by first moving to trash and only purging once reviewed to avoid accidental loss. Add a review step with labels to mark candidates before removal to keep business and personal archives safe

Query .MSG attachments with CQL, for example: type = attachment AND title ~ ".msg" (optionally scoped by space/creator/date) and export results via the REST content search endpoint for review


Reference KB articles

https://developer.atlassian.com/server/confluence/cql-field-reference/

https://developer.atlassian.com/server/confluence/advanced-searching-using-cql/

Thanks

Jayesh R